public void UpdateUnitPriceList(string[] unitPriceList, UserModel um)
{
var trashItemsMeasurementList = db.trashMeasurementModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var tableId = trashItemsMeasurementList.TableID;
try
{
var trashItmMeasurement = new TrashItemMeasurements()
{
TableID = tableId,
ItemUnitPrice1 = unitPriceList[0],
ItemUnitPrice2 = unitPriceList[1],
ItemUnitPrice3 = unitPriceList[2],
ItemUnitPrice4 = unitPriceList[3],
ItemUnitPrice5 = unitPriceList[4],
ItemUnitPrice6 = unitPriceList[5],
ItemUnitPrice7 = unitPriceList[6],
ItemUnitPrice8 = unitPriceList[7],
ItemUnitPrice9 = unitPriceList[8],
ItemUnitPrice10 = unitPriceList[9],
ItemUnitPrice11 = unitPriceList[10],
ItemUnitPrice12 = unitPriceList[11],
ItemUnitPrice13 = unitPriceList[12],
ItemUnitPrice14 = unitPriceList[13],
ItemUnitPrice15 = unitPriceList[14]
};
using (DataContext db2 = new DataContext())
{
db2.trashMeasurementModel.Attach(trashItmMeasurement);
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice1).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice2).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice3).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice4).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice5).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice6).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice7).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice8).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice9).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice10).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice11).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice12).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice13).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice14).IsModified = true;
db2.Entry(trashItmMeasurement).Property(x => x.ItemUnitPrice15).IsModified = true;
db2.SaveChanges();
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
Debug.WriteLine(ex.Message);
}
}
public List <string> FindUnitPriceList(TrashItemMeasurements trashItemsMeasurementList)
{
List <string> finalUnitPriceList = new List <string>();
List <string> priceList = UnitPriceListWithNullValues(trashItemsMeasurementList);
for (int i = 0; i < priceList.Count(); i++)
{
if (priceList[i] != null && priceList[i] != "")
{
finalUnitPriceList.Add(priceList[i]);
}
}
return(finalUnitPriceList);
}
public List <string> FindTrashItemList(TrashItemMeasurements trashItemsMeasurementList)
{
List <string> finalItemList = new List <string>();
List <string> itemList = ItemListWithNullValues(trashItemsMeasurementList);
for (int i = 0; i < itemList.Count(); i++)
{
if (itemList[i] != null && itemList[i] != "")
{
finalItemList.Add(itemList[i]);
}
}
return(finalItemList);
}
public List <string> ItemListWithNullValues(TrashItemMeasurements trashItemsMeasurementList)
{
List <string> itemList = new List <string>();
itemList.Add(trashItemsMeasurementList.ItemName1);
itemList.Add(trashItemsMeasurementList.ItemName2);
itemList.Add(trashItemsMeasurementList.ItemName3);
itemList.Add(trashItemsMeasurementList.ItemName4);
itemList.Add(trashItemsMeasurementList.ItemName5);
itemList.Add(trashItemsMeasurementList.ItemName6);
itemList.Add(trashItemsMeasurementList.ItemName7);
itemList.Add(trashItemsMeasurementList.ItemName8);
itemList.Add(trashItemsMeasurementList.ItemName9);
itemList.Add(trashItemsMeasurementList.ItemName10);
return(itemList);
}
public List <string> TypeListWithNullValues(TrashItemMeasurements trashItemsMeasurementList)
{
List <string> typeList = new List <string>();
typeList.Add(trashItemsMeasurementList.ItemType1);
typeList.Add(trashItemsMeasurementList.ItemType2);
typeList.Add(trashItemsMeasurementList.ItemType3);
typeList.Add(trashItemsMeasurementList.ItemType4);
typeList.Add(trashItemsMeasurementList.ItemType5);
typeList.Add(trashItemsMeasurementList.ItemType6);
typeList.Add(trashItemsMeasurementList.ItemType7);
typeList.Add(trashItemsMeasurementList.ItemType8);
typeList.Add(trashItemsMeasurementList.ItemType9);
typeList.Add(trashItemsMeasurementList.ItemType10);
return(typeList);
}
public List <string> UnitPriceListWithNullValues(TrashItemMeasurements trashItemsMeasurementList)
{
List <string> priceList = new List <string>();
priceList.Add(trashItemsMeasurementList.ItemUnitPrice1);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice2);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice3);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice4);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice5);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice6);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice7);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice8);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice9);
priceList.Add(trashItemsMeasurementList.ItemUnitPrice10);
return(priceList);
}
public void UpdateItemNames(string[] itemNameList, UserModel um)
{
var trashItemsMeasurementList = db.trashMeasurementModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var tableId = trashItemsMeasurementList.TableID;
var trashItmMeasurement = new TrashItemMeasurements()
{
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.trashMeasurementModel.Attach(trashItmMeasurement);
db.Entry(trashItmMeasurement).Property(x => x.ItemName1).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName2).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName3).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName4).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName5).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName6).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName7).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName8).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName9).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName10).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName11).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName12).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName13).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName14).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemName15).IsModified = true;
db.SaveChanges();
}
}
public void CreateDefaultMeasurementTypes(string companyName)
{
try
{
DataContext dc4 = new DataContext();
TrashItemMeasurements defaultMeasurements = new TrashItemMeasurements();
defaultMeasurements.CompanyName = companyName;
defaultMeasurements.ItemName1 = "Plastic";
defaultMeasurements.ItemType1 = "Kilogram";
defaultMeasurements.ItemUnitPrice1 = "10";
defaultMeasurements.ItemName2 = "Glass";
defaultMeasurements.ItemType2 = "Bottle";
defaultMeasurements.ItemUnitPrice2 = "5";
defaultMeasurements.ItemName3 = "Polythene";
defaultMeasurements.ItemType3 = "Kilogram";
defaultMeasurements.ItemUnitPrice3 = "10";
defaultMeasurements.ItemName4 = "E-waste";
defaultMeasurements.ItemType4 = "Default Trash Bag";
defaultMeasurements.ItemUnitPrice4 = "100";
defaultMeasurements.ItemName5 = "Cardboard";
defaultMeasurements.ItemType5 = "Default Trash Bag";
defaultMeasurements.ItemUnitPrice5 = "100";
using (dc4)
{
dc4.trashMeasurementModel.Add(defaultMeasurements);
dc4.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public void UpdateMeasurementTypes(string[] measurementTypeList, UserModel um)
{
var trashItemsMeasurementList = db.trashMeasurementModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var tableId = trashItemsMeasurementList.TableID;
var trashItmMeasurement = new TrashItemMeasurements()
{
TableID = tableId,
ItemType1 = measurementTypeList[0],
ItemType2 = measurementTypeList[1],
ItemType3 = measurementTypeList[2],
ItemType4 = measurementTypeList[3],
ItemType5 = measurementTypeList[4],
ItemType6 = measurementTypeList[5],
ItemType7 = measurementTypeList[6],
ItemType8 = measurementTypeList[7],
ItemType9 = measurementTypeList[8],
ItemType10 = measurementTypeList[9]
};
using (DataContext db = new DataContext())
{
db.trashMeasurementModel.Attach(trashItmMeasurement);
db.Entry(trashItmMeasurement).Property(x => x.ItemType1).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType2).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType3).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType4).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType5).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType6).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType7).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType8).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType9).IsModified = true;
db.Entry(trashItmMeasurement).Property(x => x.ItemType10).IsModified = true;
db.SaveChanges();
}
}
