public SaveChangeEnum CommitTransaction()
{
SaveChangeEnum retValue = SaveChangeEnum.No_Action;
if (_transaction == null)
{
throw new ApplicationException("Cannot roll back a transaction while there is no transaction running.");
}
try
{
((IObjectContextAdapter)_dbContext).ObjectContext.SaveChanges();
_transaction.Commit();
ReleaseCurrentTransaction();
retValue = SaveChangeEnum.Saved_Successfully;
}
catch (OptimisticConcurrencyException)
{
retValue = SaveChangeEnum.Updated_By_Other_User;
RollbackTransaction();
throw;
}
catch (Exception)
{
retValue = SaveChangeEnum.No_Action;
RollbackTransaction();
throw;
}
return(retValue);
}
public SaveChangeEnum SaveChanges(SaveOptions _SaveOption)
{
SaveChangeEnum retValue = SaveChangeEnum.No_Action;
if (IsInTransaction)
{
throw new ApplicationException("A transaction is running. Call CommitTransaction instead.");
}
try
{
if (((IObjectContextAdapter)_dbContext).ObjectContext.SaveChanges(_SaveOption) > 0)
{
retValue = SaveChangeEnum.Saved_Successfully;
}
}
catch (OptimisticConcurrencyException)
{
retValue = SaveChangeEnum.Updated_By_Other_User;
}
catch (Exception)
{
retValue = SaveChangeEnum.No_Action;
}
return(retValue);
}
public SaveChangeEnum DeleteContact(int _Id)
{
SaveChangeEnum retVal = SaveChangeEnum.No_Action;
try
{
ContactDetail ContactDetail = (from ContactDetails in this.Model.ContactDetail
where ContactDetails.Id == _Id
select ContactDetails).FirstOrDefault();
if (ContactDetail != null)
{
this.UnitOfWork.BeginTransaction();
this.Delete <ContactDetail>(ContactDetail);
this._Context.SaveChanges();
retVal = this.UnitOfWork.CommitTransaction();
}
}
catch (Exception)
{
//Log Errors
}
return(retVal);
}
public SaveChangeEnum UpdateContact(ContactDetailDTO _ContactDetailDTO)
{
SaveChangeEnum retVal = SaveChangeEnum.No_Action;
try
{
ContactDetail _ContactDetail = (from cd in this.Model.ContactDetail
where cd.Id == _ContactDetailDTO.Id
select cd).FirstOrDefault();
if (_ContactDetail != null)
{
this.UnitOfWork.BeginTransaction();
_ContactDetail.FirstName = _ContactDetailDTO.FirstName;
_ContactDetail.LastName = _ContactDetailDTO.LastName;
_ContactDetail.Email = _ContactDetailDTO.Email;
_ContactDetail.PhoneNumber = _ContactDetailDTO.PhoneNumber;
_ContactDetail.Status = _ContactDetailDTO.Status;
this.Update <ContactDetail>(_ContactDetail);
this._Context.SaveChanges();
retVal = this.UnitOfWork.CommitTransaction();
}
}
catch (Exception)
{
}
return(retVal);
}
public SaveChangeEnum AddContact(ContactDetailDTO _ContactDetailDTO)
{
SaveChangeEnum retVal = SaveChangeEnum.No_Action;
try
{
this.UnitOfWork.BeginTransaction();
ContactDetail _ContactDetail = new ContactDetail();
_ContactDetail.FirstName = _ContactDetailDTO.FirstName;
_ContactDetail.LastName = _ContactDetailDTO.LastName;
_ContactDetail.Email = _ContactDetailDTO.Email;
_ContactDetail.PhoneNumber = _ContactDetailDTO.PhoneNumber;
_ContactDetail.Status = _ContactDetailDTO.Status;
this.Add <ContactDetail>(_ContactDetail);
this._Context.SaveChanges();
retVal = this.UnitOfWork.CommitTransaction();
}
catch (Exception)
{
//Log Errors
}
return(retVal);
}
