public cachivache AddCachivache(cachivache item)
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = new TimeSpan(1, 0, 0) }))
{
using (RinconDataContext db =
new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString))
{
var entity = Convert(item);
db.Cachivaches.InsertOnSubmit(entity);
try
{
db.SubmitChanges(ConflictMode.ContinueOnConflict);
scope.Complete();
}
catch (ChangeConflictException ex)
{
Trace.TraceError(ex.SerializeForLog(db));
// All database values overwrite current values.
foreach (ObjectChangeConflict occ in db.ChangeConflicts)
occ.Resolve(RefreshMode.OverwriteCurrentValues);
throw ex;
}
catch (DbException ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
return Convert(entity);
}
}
}
private static Cachivache Convert(cachivache cachivache)
{
return new Cachivache()
{
id = cachivache.id,
name = cachivache.name,
description = cachivache.description,
categoryId = cachivache.category,
price = cachivache.price,
createdBy = cachivache.createdBy,
createdDate = cachivache.createdDate,
lastUpdate = cachivache.lastUpdate,
lastUpdatedBy = cachivache.lastUpdatedBy
};
}
public void UpdateCachivache(cachivache item)
{
_respository.UpdateCachivache(item);
}
public void UpdateCachivache(cachivache item)
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = new TimeSpan(1, 0, 0) }))
{
using (RinconDataContext db =
new RinconDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString))
{
var entity = db.Cachivaches.First(delegate(Cachivache match)
{
return match.id == item.id;
});
entity.name = item.name;
entity.description = item.description;
entity.categoryId = item.category;
entity.price = item.price;
entity.createdBy = item.createdBy;
entity.createdDate = item.createdDate;
entity.lastUpdate = item.lastUpdate;
entity.lastUpdatedBy = item.lastUpdatedBy;
try
{
db.SubmitChanges(ConflictMode.ContinueOnConflict);
scope.Complete();
}
catch (ChangeConflictException ex)
{
Trace.TraceError(ex.SerializeForLog(db));
// All database values overwrite current values.
foreach (ObjectChangeConflict occ in db.ChangeConflicts)
occ.Resolve(RefreshMode.OverwriteCurrentValues);
throw ex;
}
catch (DbException ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
}
}
}
public cachivache AddCachivache(cachivache item)
{
return _respository.AddCachivache(item);
}
