public int CreateRevisitConstant(lkup_rvisit entity) { try { using ( var ctx = new ClinicDataContext(connString) ) { ctx.lkup_rvisit.Add(entity); int result = ctx.SaveChanges(); return result; } } catch ( Exception ex ) { throw ex; } }
public int Update(lkup_rvisit entity) { try { using ( var ctx = new ClinicDataContext(connString) ) { var lookupRevisit = new lkup_rvisit(); lookupRevisit = ctx.lkup_rvisit.FirstOrDefault(x => x.rvisit_id == entity.rvisit_id); if ( lookupRevisit == null ) { throw new Exception("Record doesn't exist and cannot be updated"); } // lookupRevisit.rvisit_id = entity.rvisit_id; lookupRevisit.rvisit_descn = entity.rvisit_descn; lookupRevisit.rec_updt_dt = entity.rec_updt_dt; lookupRevisit.rec_updt_user_id_cd = entity.rec_updt_user_id_cd; lookupRevisit.rvisit_ind = entity.rvisit_ind; ctx.Entry(lookupRevisit).State = System.Data.Entity.EntityState.Modified; int result = ctx.SaveChanges(); return result; } } catch ( DbEntityValidationException ex ) { throw ex; } catch ( EntityException ex ) { throw ex; } catch ( Exception ex ) { throw ex; } }