예제 #1
0
        public void CreateDefaultTrashItems(string companyName)
        {
            //find the company name in the trash item table id not in the table then create a new row and fill
            // it with defaults else ignore
            try
            {
                DataContext dc           = new DataContext();
                TrashItems  defaultItems = new TrashItems();

                defaultItems.CompanyName = companyName;
                defaultItems.ItemName1   = "Plastic";
                defaultItems.ItemName2   = "Glass";
                defaultItems.ItemName3   = "Polythene";
                defaultItems.ItemName4   = "E-waste";
                defaultItems.ItemName5   = "Cardboard";

                using (dc)
                {
                    dc.trashItemModel.Add(defaultItems);
                    dc.SaveChanges();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
예제 #2
0
        public List <string> FindItemList(TrashItems trashItemsList)
        {
            List <string> finalItemList = new List <string>();

            List <string> itemList = ItemListWithNullValues(trashItemsList);

            for (int i = 0; i < itemList.Count(); i++)
            {
                if (itemList[i] != null && itemList[i] != "")
                {
                    finalItemList.Add(itemList[i]);
                }
            }

            return(finalItemList);
        }
        private List <string> ItemListWithNullValues(TrashItems trashItemsList)
        {
            List <string> itemList = new List <string>();

            itemList.Add(trashItemsList.ItemName1);
            itemList.Add(trashItemsList.ItemName2);
            itemList.Add(trashItemsList.ItemName3);
            itemList.Add(trashItemsList.ItemName4);
            itemList.Add(trashItemsList.ItemName5);
            itemList.Add(trashItemsList.ItemName6);
            itemList.Add(trashItemsList.ItemName7);
            itemList.Add(trashItemsList.ItemName8);
            itemList.Add(trashItemsList.ItemName9);
            itemList.Add(trashItemsList.ItemName10);
            return(itemList);
        }
예제 #4
0
        public void ItemTableUpdateItemNames(string[] itemNameList, UserModel um)
        {
            var trashItemNamesList = db.trashItemModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
            var tableId            = trashItemNamesList.TableID;

            var trashItem = new TrashItems()
            {
                TableID    = tableId,
                ItemName1  = itemNameList[0],
                ItemName2  = itemNameList[1],
                ItemName3  = itemNameList[2],
                ItemName4  = itemNameList[3],
                ItemName5  = itemNameList[4],
                ItemName6  = itemNameList[5],
                ItemName7  = itemNameList[6],
                ItemName8  = itemNameList[7],
                ItemName9  = itemNameList[8],
                ItemName10 = itemNameList[9],
                ItemName11 = itemNameList[10],
                ItemName12 = itemNameList[11],
                ItemName13 = itemNameList[12],
                ItemName14 = itemNameList[13],
                ItemName15 = itemNameList[14]
            };

            using (DataContext db = new DataContext())
            {
                db.trashItemModel.Attach(trashItem);
                db.Entry(trashItem).Property(x => x.ItemName1).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName2).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName3).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName4).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName5).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName6).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName7).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName8).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName9).IsModified  = true;
                db.Entry(trashItem).Property(x => x.ItemName10).IsModified = true;
                db.Entry(trashItem).Property(x => x.ItemName11).IsModified = true;
                db.Entry(trashItem).Property(x => x.ItemName12).IsModified = true;
                db.Entry(trashItem).Property(x => x.ItemName13).IsModified = true;
                db.Entry(trashItem).Property(x => x.ItemName14).IsModified = true;
                db.Entry(trashItem).Property(x => x.ItemName15).IsModified = true;
                db.SaveChanges();
            }
        }