public int CreateSupplementalDiagnosisCat(lkup_splmtl_diag_cat entity)
{
try
{
using ( var ctx = new ClinicDataContext(connString) )
{
IdentityInsertOn<lkup_splmtl_diag_cat>(ctx, entity);
ctx.Entry(entity).State = System.Data.Entity.EntityState.Added;
int result = ctx.SaveChanges();
return result;
}
}
catch ( DbEntityValidationException ex )
{
throw ex;
}
catch ( EntityException ex )
{
throw ex;
}
catch ( Exception ex )
{
throw ex;
}
}
public int Update(lkup_splmtl_diag_cat entity)
{
try
{
using ( var ctx = new ClinicDataContext(connString) )
{
var supplementalDiagnosisCategories = ctx.lkup_splmtl_diag_cat.FirstOrDefault(x => x.splmtl_diag_cat_id == entity.splmtl_diag_cat_id);
if ( supplementalDiagnosisCategories == null )
{
throw new Exception("Record doesn't exist and cannot be updated");
}
supplementalDiagnosisCategories.splmtl_diag_cat_id = entity.splmtl_diag_cat_id;
supplementalDiagnosisCategories.splmtl_diag_cat = entity.splmtl_diag_cat;
supplementalDiagnosisCategories.user_intrfc_sort_ord = entity.user_intrfc_sort_ord;
supplementalDiagnosisCategories.splmtl_diag_cat_stat = entity.splmtl_diag_cat_stat;
supplementalDiagnosisCategories.splmtl_diag_cat_strt_eff_dt = entity.splmtl_diag_cat_strt_eff_dt;
supplementalDiagnosisCategories.splmtl_diag_cat_end_eff_dt = entity.splmtl_diag_cat_end_eff_dt;
supplementalDiagnosisCategories.rec_updt_user_id_cd = entity.rec_updt_user_id_cd;
supplementalDiagnosisCategories.rec_updt_dt = entity.rec_updt_dt;
ctx.Entry(supplementalDiagnosisCategories).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;
}
}