public int DalSaveNewPattern(object pattern) { int res = 0; Pattern_Dal pattern_dal = new Pattern_Dal(); pattern_dal = pattern as Pattern_Dal; using (KarmenDbContext db = new KarmenDbContext()) { var temp = db.Pattern.Any(c => c.CrossReference == pattern_dal.CrossReference); if (temp == false) { // Add new element to Db db.Pattern.Add(new Patterns { CrossReference = pattern_dal.CrossReference, UseUnuse = pattern_dal.UseUnuse, AdditionalInformation = pattern_dal.AdditionalInformation }); db.SaveChanges(); // Get element from Db var users = db.Pattern.Any(c => c.CrossReference == pattern_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 DalChangeExistedPattern(object pattern) { int res = 0; Pattern_Dal pattern_dal = new Pattern_Dal(); pattern_dal = pattern as Pattern_Dal; using (KarmenDbContext db = new KarmenDbContext()) { var temp = db.Pattern.FirstOrDefault(c => c.Id == pattern_dal.Id); // Change data temp.CrossReference = pattern_dal.CrossReference; temp.UseUnuse = pattern_dal.UseUnuse; temp.AdditionalInformation = pattern_dal.AdditionalInformation; //Save changes db.SaveChanges(); } res = 1; return(res); }