Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
 //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");
     }
 }
Exemplo n.º 3
0
 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");
     }
 }
Exemplo n.º 4
0
 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");
     }
 }
Exemplo n.º 5
0
 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");
     }
 }
Exemplo n.º 6
0
 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");
     }
 }
Exemplo n.º 7
0
        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);
        }
Exemplo n.º 8
0
        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");
            }
        }