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); }