public bool ExistsDispatchProviderDocumentState(int DispatchProviderDocumentStateId, out string errorMessage)
{
errorMessage = "";
try
{
DispatchProviderDocumentState obj = null;
using (var context = new Entity())
{
obj = context.DispatchProviderDocumentState.Where(r => r.DispatchProviderDocumentStateId != DispatchProviderDocumentStateId).FirstOrDefault();
if (obj == null)
{
return(false);
}
return(true);
}
}
catch (Exception ex)
{
errorMessage = ErrorController.GetErrorMessage(ex);
return(false);
}
}
public DispatchProviderDocumentState Save(DispatchProviderDocumentState objSource, out string errorMessage)
{
errorMessage = "";
try
{
using (var context = new Entity())
{
using (TransactionScope transaction = new TransactionScope())
{
DispatchProviderDocumentState service = context.DispatchProviderDocumentState.Where(r => r.DispatchProviderDocumentStateName.ToUpper() == objSource.DispatchProviderDocumentStateName.ToUpper() && r.DispatchProviderDocumentStateId != objSource.DispatchProviderDocumentStateId).FirstOrDefault();
if (service != null)
{
return((DispatchProviderDocumentState)ErrorController.SetErrorMessage("Repeated state name", out errorMessage));
}
DispatchProviderDocumentState row = context.DispatchProviderDocumentState.Where(r => r.DispatchProviderDocumentStateId == objSource.DispatchProviderDocumentStateId).FirstOrDefault();
if (row == null)
{
row = new DispatchProviderDocumentState();
Copy(objSource, ref row);
context.DispatchProviderDocumentState.Add(row);
}
else
{
Copy(objSource, ref row);
}
context.SaveChanges();
transaction.Complete();
return(row);
}
}
}
catch (Exception ex)
{
errorMessage = ErrorController.GetErrorMessage(ex);
return(null);
}
}
public CommonEnums.DeletedRecordStates DeleteDispatchProviderDocumentState(int IDispatchProviderDocumentStateId, out string errorMessage)
{
try
{
using (var context = new Entity())
{
errorMessage = "";
DispatchProviderDocumentState obj = context.DispatchProviderDocumentState.Where(r => r.DispatchProviderDocumentStateId == IDispatchProviderDocumentStateId).FirstOrDefault();
if (obj == null)
{
return(CommonEnums.DeletedRecordStates.NotFound);
}
context.DispatchProviderDocumentState.Remove(obj);
context.SaveChanges();
return(CommonEnums.DeletedRecordStates.DeletedOk);
}
}
catch (Exception ex)
{
errorMessage = ErrorController.GetErrorMessage(ex);
return(CommonEnums.DeletedRecordStates.NotDeleted);
}
}
public void Copy(DispatchProviderDocumentState objSource, ref DispatchProviderDocumentState objDestination)
{
objDestination.DispatchProviderDocumentStateId = objSource.DispatchProviderDocumentStateId;
objDestination.DispatchProviderDocumentStateName = objSource.DispatchProviderDocumentStateName;
}
