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