public int Update(curr_sys_info entity) { try { using ( var ctx = new ClinicDataContext(connString) ) { var currentSystem = ctx.curr_sys_info.FirstOrDefault(x => x.curr_sys_id == entity.curr_sys_id); if ( currentSystem == null ) { throw new Exception("Record doesn't exist and cannot be updated"); } currentSystem.curr_sys_id = entity.curr_sys_id; currentSystem.itm_vrsn = entity.itm_vrsn; currentSystem.itm_descn = entity.itm_descn; currentSystem.dt_of_rlse = entity.dt_of_rlse; ctx.Entry(currentSystem).State = System.Data.Entity.EntityState.Modified; int result = ctx.SaveChanges(); return result; } } catch ( Exception ex ) { throw ex; } }
public int CreateCurrentSystemInfo(curr_sys_info entity) { try { using ( var ctx = new ClinicDataContext(connString) ) { ctx.curr_sys_info.Add(entity); int result = ctx.SaveChanges(); return result; } } catch ( Exception ex ) { throw ex; } }