/// <summary> /// To update record about stand in database /// </summary> /// <param name="stand"></param> /// <returns></returns> public int UpdateStand(Stand stand) { using (var db = new StandCommercialContext()) { db.Entry(stand).State = EntityState.Modified; db.SaveChanges(); return(stand.Id); } }
/// <summary> /// To add record about stand in database /// </summary> /// <param name="stand"></param> /// <returns></returns> public int AddStand(Stand stand) { using (var db = new StandCommercialContext()) { db.Stands.Add(stand); db.SaveChanges(); db.Entry(stand).GetDatabaseValues(); return(stand.Id); } }
/// <summary> /// Add record about commercial, and records abot mapping comercial and stands, in databases /// </summary> /// <param name="commercial"></param> /// <param name="standId"></param> /// <returns></returns> public int AddCommercialCurrentStand(Commercial commercial, List <int> standId) { using (var db = new StandCommercialContext()) { db.Commercials.Add(commercial); db.SaveChanges(); var stand = new Stand(); foreach (var id in standId) { stand = db.Stands.Find(id); commercial.StandCommercials.Add(new StandCommercial { CommercialId = commercial.Id, StandId = stand.Id }); db.SaveChanges(); } db.Entry(commercial).GetDatabaseValues(); // потом попробывать без этого return(commercial.Id); } }