public Update ( |
||
entity | ||
리턴 | int |
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;
}
}
public int UpdateRevisit(RevisitModel model) { var repo = new RevisitRepository(); var dataModel = new HealthInformationProgram.Data.Tables.lkup_rvisit(); dataModel.rvisit_id = Convert.ToDecimal(model.RevisitId); dataModel.rvisit_ind = model.Indicator; dataModel.rvisit_descn = model.Description; dataModel.user_intrfc_sort_ord = Convert.ToDecimal(model.SortOrder); dataModel.rec_updt_dt = DateTime.Now; dataModel.rec_updt_user_id_cd = "dbadmin"; //TODO: change to use AD when wired up try { var returnCode = repo.Update(dataModel); return returnCode; } catch ( Exception ex ) { throw ex; } }