public Update ( |
||
entity | ||
return | int |
public int Update(lkup_splmtl_diag entity)
{
try
{
using ( var ctx = new ClinicDataContext(connString) )
{
var supplementalDiagnosis = ctx.lkup_splmtl_diag.FirstOrDefault(x => x.splmtl_diag_id == entity.splmtl_diag_id);
if ( supplementalDiagnosis == null )
{
throw new Exception("Record doesn't exist and cannot be updated");
}
supplementalDiagnosis.diag_id = entity.diag_id;
supplementalDiagnosis.splmtl_diag_id = entity.splmtl_diag_id;
supplementalDiagnosis.splmtl_diag_descn = entity.splmtl_diag_descn;
supplementalDiagnosis.rec_updt_user_id_cd = entity.rec_updt_user_id_cd;
supplementalDiagnosis.rec_updt_dt = entity.rec_updt_dt;
supplementalDiagnosis.user_intrfc_sort_ord = entity.user_intrfc_sort_ord;
supplementalDiagnosis.splmtl_diag_stat = entity.splmtl_diag_stat;
supplementalDiagnosis.splmtl_diag_strt_eff_dt = entity.splmtl_diag_strt_eff_dt;
supplementalDiagnosis.splmtl_diag_end_eff_dt = entity.splmtl_diag_end_eff_dt;
ctx.Entry(supplementalDiagnosis).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 UpdateSupplementalDiagnosis(SupplementalDiagnosisModel model) { var repo = new SupplementalDiagnosisRepository(); var dataModel = new HealthInformationProgram.Data.Tables.lkup_splmtl_diag(); dataModel.diag_id = Convert.ToDecimal(model.DiagnosisId); dataModel.splmtl_diag_id = Convert.ToDecimal(model.SupplementalDiagnosisId); dataModel.splmtl_diag_stat = model.Status; dataModel.splmtl_diag_descn = model.SupplementalDiagnosisDescription; dataModel.user_intrfc_sort_ord = Convert.ToDecimal(model.SortOrder); dataModel.splmtl_diag_strt_eff_dt = Convert.ToDateTime(model.SupplementalDiagnosisEffectiveStartDate); dataModel.splmtl_diag_end_eff_dt = Convert.ToDateTime(model.SupplementalDiagnosisEffectiveEndDate); dataModel.rec_updt_dt = DateTime.Now; dataModel.rec_updt_user_id_cd = model.UpdatedBy; try { var returnCode = repo.Update(dataModel); return returnCode; } catch (Exception ex) { throw ex; } }