public int Update(curr_sys_info entity)
{
try
{
using ( var ctx = new ClinicDataContext(connString) )
{
var currentSystem = ctx.curr_sys_info.FirstOrDefault(x => x.curr_sys_id == entity.curr_sys_id);
if ( currentSystem == null )
{
throw new Exception("Record doesn't exist and cannot be updated");
}
currentSystem.curr_sys_id = entity.curr_sys_id;
currentSystem.itm_vrsn = entity.itm_vrsn;
currentSystem.itm_descn = entity.itm_descn;
currentSystem.dt_of_rlse = entity.dt_of_rlse;
ctx.Entry(currentSystem).State = System.Data.Entity.EntityState.Modified;
int result = ctx.SaveChanges();
return result;
}
}
catch ( Exception ex )
{
throw ex;
}
}
public int CreateCurrentSystemInfo(curr_sys_info entity)
{
try
{
using ( var ctx = new ClinicDataContext(connString) )
{
ctx.curr_sys_info.Add(entity);
int result = ctx.SaveChanges();
return result;
}
}
catch ( Exception ex )
{
throw ex;
}
}
