public IList <BusinessObjects.BizMsg> GetAll()
{
using (Database db = DataContextFactory.CreateContext())
{
return(db.BizMsgs.Select(x => BizMsgMapper.ToBusinessObject(x)).ToList());
}
}
public void Delete(BusinessObjects.BizMsg model)
{
NiCris.DataAccess.SQL.LinqToSQL.BizMsg entity = BizMsgMapper.ToEntity(model);
using (Database db = DataContextFactory.CreateContext())
{
try
{
db.BizMsgs.Attach(entity, false);
db.BizMsgs.DeleteOnSubmit(entity);
db.SubmitChanges();
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict conflict in db.ChangeConflicts)
{
conflict.Resolve(RefreshMode.KeepCurrentValues);
}
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
throw new Exception("A concurrency error occurred!");
}
}
catch (Exception ex)
{
throw new Exception("There was an error updating the record! " + ex.Message);
}
}
}
public BusinessObjects.BizMsg GetById(int id)
{
using (Database db = DataContextFactory.CreateContext())
{
return(BizMsgMapper.ToBusinessObject(db.BizMsgs
.Where(x => x.Id == id)
.SingleOrDefault()));
}
}
public int Update(BusinessObjects.BizMsg model)
{
// Validate the BO
var errorInfo = Validator.Check(model);
if (errorInfo.Count() > 0)
{
throw new Exception("Validation error(s) occurred! Please make sure all validation rules are met.");
}
NiCris.DataAccess.SQL.LinqToSQL.BizMsg entity = BizMsgMapper.ToEntity(model);
using (Database db = DataContextFactory.CreateContext())
{
try
{
db.BizMsgs.Attach(entity, true);
db.SubmitChanges();
model.Id = entity.Id;
model.RowVersion = VersionConverter.ToString(entity.rowversion);
return(entity.Id);
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict conflict in db.ChangeConflicts)
{
conflict.Resolve(RefreshMode.KeepCurrentValues);
}
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
throw new Exception("A concurrency error occurred!");
}
return(entity.Id);
}
catch (Exception ex)
{
throw new Exception("There was an error updating the record! " + ex.Message);
}
}
}
