public bool SaveTreatmentMatrail(IEnumerable <MatrailToSaveViewModel> matrailList, int treatmentID)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
foreach (var item in matrailList)
{
MaterialTreatment materialTreatment = ctx.MaterialTreatments.Where(x => x.TeratmentID == treatmentID && x.MaterialID == item.MatrailID).FirstOrDefault();
if (materialTreatment == null)
{
materialTreatment = ctx.MaterialTreatments.Create();
materialTreatment.TeratmentID = treatmentID;
materialTreatment.MaterialID = item.MatrailID;
materialTreatment.MaterialCost = ctx.Materials.Find(item.MatrailID).MaterialCost;
materialTreatment.Quantity = item.Quantity;
ctx.MaterialTreatments.Add(materialTreatment);
}
else
{
materialTreatment.Quantity = item.Quantity;
ctx.Entry(materialTreatment).State = System.Data.Entity.EntityState.Modified;
}
count += ctx.SaveChanges();
}
}
return(count > 0 ? true : false);
}
public int getQuanityOfMatrailTreatment(int matrailID, int treatmentID)
{
int quantity = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
MaterialTreatment mt = ctx.MaterialTreatments.Where(x => x.MaterialID == matrailID && x.TeratmentID == treatmentID).FirstOrDefault();
if (mt == null)
{
return(0);
}
quantity = (int)mt.Quantity;
}
return(quantity);
}
public bool removeTreatmentMatrail(int matrailID, int treatmentID)
{
int count = 0;
using (Entities.Entities ctx = new Entities.Entities())
{
var matrailIQ = ctx.Materials;
MaterialTreatment mt = ctx.MaterialTreatments.Where(x => x.MaterialID == matrailID && x.TeratmentID == treatmentID).FirstOrDefault();
if (mt == null)
{
return(false);
}
ctx.MaterialTreatments.Remove(mt);
count = ctx.SaveChanges();
}
return(count > 0 ? true : false);
}
