<pre lang="HTML"> private void LoadDeliveryNoteDetails(string PickingNoteNo) { dtDeliveryNoteDetails = new DataTable(); try { using (QuotationBusiness objQuotationBusiness = new QuotationBusiness()) { dtDeliveryNoteDetails = objQuotationBusiness.GetDeliveryNoteDetails(PickingNoteNo); } if (dtDeliveryNoteDetails != null) { gvDeliveryNoteDetails.DataSource = dtDeliveryNoteDetails; HideGridViewColumns(); LoadCustomerDetails(); LoadDeliveryDetails(); LoadFreightDetails(); LoadPackagingTypeDetails(); LoadShippingBoxDetails(); } } catch (Exception ex) { } } private void HideGridViewColumns() { foreach (DataGridViewColumn column in gvDeliveryNoteDetails.Columns) { if (column.Name != "ItemCode" && column.Name != "Quantity" && column.Name != "Description" && column.Name != "BatchNo" && column.Name != "ExpiryDate" && column.Name != "Packaging Type") { column.Visible = false; } } } private void LoadPackagingTypeDetails() { DataGridViewComboBoxColumn cmbpackingtype = new DataGridViewComboBoxColumn(); cmbpackingtype.Name = "cmbPackingTypes"; cmbpackingtype.HeaderText = "Packaging Type"; gvDeliveryNoteDetails.Columns.Add(cmbpackingtype); using (QuotationBusiness objQB = new QuotationBusiness()) { DataTable dtPackingTypes = objQB.GetPackagingTypeDetails(); if (dtPackingTypes != null) { DataRow row = dtPackingTypes.NewRow(); row["PackageType"] = "Select"; row["PackageTypeID"] = 0; dtPackingTypes.Rows.InsertAt(row, 0); cmbpackingtype.ValueMember = "PackageTypeID"; cmbpackingtype.DisplayMember = "PackageType"; cmbpackingtype.DataSource = dtPackingTypes; cmbpackingtype.DisplayIndex = 0; } } } private void LoadShippingBoxDetails() { DataGridViewComboBoxColumn cmbBox = new DataGridViewComboBoxColumn(); cmbBox.Name = "cmbBoxNos"; cmbBox.HeaderText = "Box No"; gvDeliveryNoteDetails.Columns.Add(cmbBox); using (EmployeeMasterBusiness objEmp = new EmployeeMasterBusiness()) { DataTable dtBoxNos = objEmp.GetDepartmentDetails(); if (dtBoxNos != null) { DataRow row = dtBoxNos.NewRow(); row["DeptName"] = "Select"; row["DeptID"] = 0; dtBoxNos.Rows.InsertAt(row, 0); cmbBox.DataSource = dtBoxNos; cmbBox.DisplayMember = "DeptName"; cmbBox.ValueMember = "DeptID"; } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)