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