public static string fillCatalogValueGridViewCombo(DataGridViewComboBoxCell cmb, string catalogvalue) { string firstValue = ""; cmb.Items.Clear(); try { CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals(catalogvalue) && catval.status == 1) { cmb.Items.Add(catval.catalogueValueID + "-" + catval.description); if (firstValue.Length == 0) { firstValue = catval.catalogueValueID + "-" + catval.description; } } } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(firstValue); }
//Grid View Combobox column public static void fillCatalogValueGridViewComboNew(System.Windows.Forms.DataGridViewComboBoxCell cmb, string catalogvalue) { try { cmb.Items.Clear(); CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); List <Structures.GridViewComboBoxItem> ItemList = new List <Structures.GridViewComboBoxItem>(); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals(catalogvalue) && catval.status == 1) { Structures.GridViewComboBoxItem ch = new Structures.GridViewComboBoxItem(catval.description, catval.catalogueValueID); cmb.Items.Add(ch); } } cmb.DisplayMember = "Name"; // Name Property will show(Editing) cmb.ValueMember = "Value"; // Value Property will save(Saving) } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }
public static void fillCatalogValueListBox(ListBox lb, string catalogvalue) { try { CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals(catalogvalue) && catval.status == 1) { lb.Items.Add(catval.description); } } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }
public static void fillCustomerComboNew(System.Windows.Forms.ComboBox cmb, string catalogvalue) { cmb.Items.Clear(); try { CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals(catalogvalue) && catval.status == 1) { cmb.Items.Add(catval.catalogueValueID + "-" + catval.description); } } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }
public static void fillInwardDocCombo(System.Windows.Forms.ComboBox cmb, string catalogvalue) { cmb.Items.Clear(); try { CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals(catalogvalue) && catval.status == 1) { cmb.Items.Add(catval.catalogueValueID); } } } catch (Exception ex) { MessageBox.Show("fillCatalogValueCombo() : Error"); } }
public static void fillToLocationCombo(ComboBox cmb, string Location) { cmb.Items.Clear(); try { CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals("StoreLocation") && catval.status == 1) { if (catval.catalogueValueID.ToString() != Location) { cmb.Items.Add(catval.catalogueValueID + "-" + catval.description); } } } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }
public static ListView getCatalogValueListView(string catalogueID) { ListView lv = new ListView(); try { lv.View = View.Details; lv.LabelEdit = true; lv.AllowColumnReorder = true; lv.CheckBoxes = true; lv.FullRowSelect = true; lv.GridLines = true; lv.Sorting = System.Windows.Forms.SortOrder.Ascending; CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues(); lv.Columns.Add("Select", -2, HorizontalAlignment.Left); lv.Columns.Add("Catalouge ID", -2, HorizontalAlignment.Left); lv.Columns.Add("CV Description", -2, HorizontalAlignment.Left); foreach (cataloguevalue catval in CatalogueValues) { if (catval.catalogueID.Equals(catalogueID) && catval.status == 1) { ListViewItem item1 = new ListViewItem(); item1.Checked = false; item1.SubItems.Add(catval.catalogueValueID.ToString()); item1.SubItems.Add(catval.description); lv.Items.Add(item1); } } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(lv); }
public static void fillCatalogValueComboNew2(System.Windows.Forms.ComboBox cmb, System.Windows.Forms.ComboBox cmb2, System.Windows.Forms.ComboBox cmb3, System.Windows.Forms.Label Label) { cmb.Items.Clear(); cmb2.Items.Clear(); cmb3.Items.Clear(); try { CatalogueValueDB dbrecord = new CatalogueValueDB(); List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues().Where(W => W.catalogueID == "POType").ToList(); List <documentreceiver> ListL2 = new List <documentreceiver>(); List <documentreceiver> ListL3 = new List <documentreceiver>(); List <documentreceiver> ListL = Main.DocumentReceivers.Where(W => W.Status == 1).ToList(); OfficeDB obj2 = new OfficeDB(); DocumentDB obj3 = new DocumentDB(); var Ofices = obj2.getOffices().Where(W => W.status == 1).ToList(); string DocName = ""; foreach (var itm in ListL) { documentreceiver obj = new documentreceiver(); DocName = itm.DocumentID; DocName = DocName.Replace("POSERVICEINWARD", "Service PO"); DocName = DocName.Replace("PAFSERVICEINWARD", "ServicePAF"); DocName = DocName.Replace("POPRODUCTINWARD", "Product PO"); DocName = DocName.Replace("PAFPRODUCTINWARD", "ProductPAF"); obj.DocumentName = DocName; obj.OfficeID = itm.OfficeID; obj.OfficeName = itm.OfficeName; obj.DocumentID = itm.DocumentID; ListL2.Add(obj); } string[] Str = new string[4]; ////int i = 0; foreach (var itm in CatalogueValues) { documentreceiver obj = new documentreceiver(); DocName = itm.description; DocName = DocName.Replace("Service PO", "POSERVICEINWARD"); DocName = DocName.Replace("ServicePAF", "PAFSERVICEINWARD"); DocName = DocName.Replace("Product PO", "POPRODUCTINWARD"); DocName = DocName.Replace("ProductPAF", "PAFPRODUCTINWARD"); obj.DocumentID = DocName; obj.DocumentName = itm.description; ListL3.Add(obj); } var abcsd = from Ca in CatalogueValues join Ll in ListL2 on Ca.description equals Ll.DocumentName select new { DocumentName = Ca.description, DocumentID = Ll.DocumentID, Ofice = Ll.OfficeID, OficeName = Ll.OfficeName }; var Off = from Ca in Ofices join Ll in abcsd on Ca.OfficeID equals Ll.Ofice select Ca; // cmb.Items.AddRange(ListL.ToArray()); foreach (var itm in abcsd.GroupBy(x => x.DocumentName).Select(y => y.FirstOrDefault()).ToList()) { Structures.ComboBoxItem cbitem = new Structures.ComboBoxItem(itm.DocumentName, itm.DocumentID); cmb.Items.Add(cbitem); } var Abcd2 = abcsd.GroupBy(x => x.Ofice).Select(y => y.FirstOrDefault()).ToList(); foreach (var itm in Abcd2) { Structures.ComboBoxItem cbitem2 = new Structures.ComboBoxItem(itm.OficeName, itm.Ofice); cmb2.Items.Add(cbitem2); } foreach (var itm in Ofices.GroupBy(G => G.RegionID)) { Structures.ComboBoxItem cbitem = new Structures.ComboBoxItem(itm.Key, itm.Select(s => s.RegionName).FirstOrDefault()); cmb3.Items.Add(cbitem); } if (ListL.Count <= 0) { Label.Text = "1"; var Documents = obj3.getDocuments().Where(W => W.DocumentStatus == 1).ToList(); var results = from x in Documents join Ll in ListL3 on x.DocumentID equals Ll.DocumentID select new { DocumntId = x.DocumentID, documntname = Ll.DocumentName }; foreach (var itm in results) { Structures.ComboBoxItem cbitem = new Structures.ComboBoxItem(itm.documntname, itm.DocumntId); cmb.Items.Add(cbitem); } foreach (var itm in Ofices) { Structures.ComboBoxItem cbitem = new Structures.ComboBoxItem(itm.name, itm.OfficeID); cmb2.Items.Add(cbitem); } // offli = Ofices.ToList(); } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }