public int DalSaveNewMaterialOfSole(object materialOfSole) { int res = 0; MaterialOfSole_Dal materialOfSole_dal = new MaterialOfSole_Dal(); materialOfSole_dal = materialOfSole as MaterialOfSole_Dal; using (KarmenDbContext db = new KarmenDbContext()) { var temp = db.MaterialOfSole.Any(c => c.Name == materialOfSole_dal.Name && c.CrossReference == materialOfSole_dal.CrossReference); if (temp == false) { // Add new element to Db db.MaterialOfSole.Add(new MaterialsOfSole { Name = materialOfSole_dal.Name, IdColour = materialOfSole_dal.IdColour, CrossReference = materialOfSole_dal.CrossReference, UseUnuse = materialOfSole_dal.UseUnuse }); db.SaveChanges(); // Get element from Db var users = db.MaterialOfSole.Any(c => c.Name == materialOfSole_dal.Name && c.CrossReference == materialOfSole_dal.CrossReference); res = (users == false) ? 0 : 1; //0 - Saving Error; 1 - Saving is correct } else { res = 2; //This note is already created in Db } } return(res); }
public int DalChangeExistedMaterialOfSole(object materialOfSole) { int res = 0; MaterialOfSole_Dal materialOfSole_dal = new MaterialOfSole_Dal(); materialOfSole_dal = materialOfSole as MaterialOfSole_Dal; using (KarmenDbContext db = new KarmenDbContext()) { var temp = db.MaterialOfSole.FirstOrDefault(c => c.Id == materialOfSole_dal.Id); // Change data temp.Name = materialOfSole_dal.Name; temp.IdColour = materialOfSole_dal.IdColour; temp.CrossReference = materialOfSole_dal.CrossReference; temp.UseUnuse = materialOfSole_dal.UseUnuse; //Save changes db.SaveChanges(); } res = 1; return(res); }