public int Update(raw_visit entity) { try { using ( var ctx = new ClinicDataContext(connString) ) { var rawVisit = ctx.raw_visit.FirstOrDefault(x => x.visit_uuid == entity.visit_uuid); if ( rawVisit == null ) { throw new Exception("Record doesn't exist and cannot be updated"); } rawVisit.visit_uuid = entity.visit_uuid; rawVisit.visit_stat = entity.visit_stat; rawVisit.visit_json = entity.visit_json; rawVisit.err_cd = entity.err_cd; rawVisit.rec_updt_user_id_cd = entity.rec_updt_user_id_cd; rawVisit.rec_updt_dt = entity.rec_updt_dt; ctx.Entry(rawVisit).State = System.Data.Entity.EntityState.Modified; int result = ctx.SaveChanges(); return result; } } catch ( Exception ex ) { throw ex; } }
public int CreateRawVisit(raw_visit entity) { try { using ( var ctx = new ClinicDataContext(connString) ) { ctx.raw_visit.Add(entity); int result = ctx.SaveChanges(); return result; } } catch ( Exception ex ) { throw ex; } }