public int DalSaveNewFootBed(object footBed) { int res = 0; FootBed_Dal footBed_dal = new FootBed_Dal(); footBed_dal = footBed as FootBed_Dal; using (KarmenDbContext db = new KarmenDbContext()) { var temp = db.Footbed.Any(c => c.Type == footBed_dal.Type && c.CrossReference == footBed_dal.CrossReference); if (temp == false) { // Add new element to Db db.Footbed.Add(new Footbeds { Type = footBed_dal.Type, CrossReference = footBed_dal.CrossReference, AdditionalInformation = footBed_dal.AdditionalInformation }); db.SaveChanges(); // Get element from Db var users = db.Footbed.Any(c => c.Type == footBed_dal.Type && c.CrossReference == footBed_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 DalChangeExistedFootBed(object footBed) { int res = 0; FootBed_Dal footBed_dal = new FootBed_Dal(); footBed_dal = footBed as FootBed_Dal; using (KarmenDbContext db = new KarmenDbContext()) { var temp = db.Footbed.FirstOrDefault(c => c.Id == footBed_dal.Id); //Change selected data temp.Type = footBed_dal.Type; temp.CrossReference = footBed_dal.CrossReference; temp.AdditionalInformation = footBed_dal.AdditionalInformation; //Save changes db.SaveChanges(); } res = 1; return(res); }