public static int createFamily(tblFamily c) { var res = -1; try { using (var db = new BusProjectEntities()) { var pid = 0; int.TryParse(db.tblFamilies.Max(z => z.ParentId), out pid); c.ParentId = (pid + 1).ToString(); c.date = DateTime.Today; c.LastUpdate = DateTime.Today; c.registrationStatus = false; db.tblFamilies.Add(c); db.SaveChanges(); res = c.familyId; } } catch (DbEntityValidationException ex) { var e = ex.EntityValidationErrors.FirstOrDefault(); throw; } return(res); }
public static void update(tblFamily c) { try { BusProjectEntities db = new BusProjectEntities(); db.Entry <tblFamily>(c).State = EntityState.Modified; db.SaveChanges(); } catch { } }