public ResultContainer AddAction(WebOrderRequestAction entity)
{
const string COMMAND_TEXT = "usp_WebOrderRequestAction_Insert";
ResultContainer resultContainer = new ResultContainer();
try
{
using (SqlConnection cn = DataContext.GetConnection(this.GetConnectionStringKey(_context)))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = COMMAND_TEXT;
cmd.Parameters.AddWithValue("@web_order_request_id", entity.WebOrderRequestID);
cmd.Parameters.AddWithValue("@action_code", entity.ActionCode);
cmd.Parameters.AddWithValue("@created_by", entity.CreatedByCooperatorID);
if (String.IsNullOrEmpty(entity.Note))
{
cmd.Parameters.AddWithValue("@note", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@note", entity.Note);
}
SqlParameter errorParam = new SqlParameter();
errorParam.SqlDbType = System.Data.SqlDbType.Int;
errorParam.ParameterName = "@out_error_number";
errorParam.Direction = System.Data.ParameterDirection.Output;
errorParam.Value = 0;
cmd.Parameters.Add(errorParam);
cmd.ExecuteNonQuery();
resultContainer.EntityID = entity.ID;
resultContainer.ResultCode = cmd.Parameters["@out_error_number"].Value.ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(resultContainer);
}
public IQueryable <WebOrderRequestAction> SearchActions(int webOrderRequestId)
{
const string COMMAND_TEXT = "usp_WebOrderRequestActions_Select";
List <WebOrderRequestAction> webOrderRequestActions = new List <WebOrderRequestAction>();
try
{
using (SqlConnection cn = DataContext.GetConnection(this.GetConnectionStringKey(_context)))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = COMMAND_TEXT;
cmd.Parameters.AddWithValue("@web_order_request_id", webOrderRequestId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
WebOrderRequestAction webOrderRequestAction = new WebOrderRequestAction();
webOrderRequestAction.ID = GetInt(reader["web_order_request_action_id"].ToString());
webOrderRequestAction.WebOrderRequestID = webOrderRequestId;
webOrderRequestAction.Title = reader["action_title"].ToString();
webOrderRequestAction.ActionCode = reader["action_code"].ToString();
webOrderRequestAction.ActionDateTime = GetDate(reader["action_date"].ToString());
webOrderRequestAction.ActionDate = GetDate(reader["action_date_converted"].ToString());
webOrderRequestAction.Description = reader["action_description"].ToString();
webOrderRequestAction.Note = reader["note"].ToString();
webOrderRequestAction.CreatedByCooperatorID = GetInt(reader["created_by"].ToString());
webOrderRequestAction.CreatedByCooperatorName = reader["created_by_name"].ToString();
webOrderRequestActions.Add(webOrderRequestAction);
}
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
return(webOrderRequestActions.AsQueryable());
}
private WebOrderRequestEditViewModel GetData(int id, bool reviewMode)
{
ResultContainer resultContainer = null;
WebOrderRequest webOrderRequest = null;
GRINGlobalService grinGlobalService = new GRINGlobalService(this.AuthenticatedUserSession.Environment);
WebOrderRequestEditViewModel viewModel = new WebOrderRequestEditViewModel();
try
{
if (reviewMode)
{
resultContainer = grinGlobalService.SetReviewStatus(id, AuthenticatedUser.Cooperator.WebCooperator.ID, true);
resultContainer = grinGlobalService.AddWebOrderRequestAction(new WebOrderRequestAction {
WebOrderRequestID = id, ActionCode = "NRR_REVIEW", CreatedByCooperatorID = AuthenticatedUser.WebUserID
});
}
webOrderRequest = grinGlobalService.GetWebOrderRequest(id);
if (webOrderRequest == null)
{
throw new NullReferenceException(String.Format("Null web order request returned for ID {0}", id));
}
viewModel.AuthenticatedUser = AuthenticatedUser;
viewModel.WebCooperatorID = AuthenticatedUser.Cooperator.WebCooperator.ID;
viewModel.StatusCode = webOrderRequest.StatusCode;
viewModel.OrderDate = webOrderRequest.OrderDate;
viewModel.WebCooperator = webOrderRequest.Cooperators.First();
viewModel.IsReviewMode = reviewMode;
viewModel.IsLocked = webOrderRequest.IsLocked;
viewModel.ID = webOrderRequest.ID;
viewModel.OrderDate = webOrderRequest.OrderDate;
viewModel.IntendedUseCode = webOrderRequest.IntendedUseCode;
viewModel.IntendedUseNote = webOrderRequest.IntendedUseNote;
viewModel.Note = webOrderRequest.Note;
viewModel.SpecialInstruction = webOrderRequest.SpecialInstruction;
viewModel.OwnedDate = webOrderRequest.OwnedDate;
viewModel.OwnedByCooperatorID = webOrderRequest.OwnedByCooperatorID;
viewModel.OwnedByCooperatorName = webOrderRequest.OwnedByCooperatorName;
viewModel.WebOrderRequestItems = webOrderRequest.WebOrderRequestItems;
viewModel.WebOrderRequestAddresses = webOrderRequest.Addresses;
viewModel.EmailAddressList = webOrderRequest.EmailAddressList;
viewModel.EmailTemplates = grinGlobalService.GetEmailTemplates();
var queryWebOrderRequestDates =
from action in webOrderRequest.WebOrderRequestActions
group action by action.ActionDate into webOrderRequestActionGroup
orderby webOrderRequestActionGroup.Key descending
select webOrderRequestActionGroup;
foreach (var group in queryWebOrderRequestDates)
{
WebOrderRequestActionGroupViewModel webOrderRequestActionGroupViewModel = new WebOrderRequestActionGroupViewModel();
webOrderRequestActionGroupViewModel.ActionDate = DateTime.Parse(group.Key.ToString());
foreach (var subGroup in group)
{
WebOrderRequestAction webOrderRequestAction = new WebOrderRequestAction();
webOrderRequestAction.ID = subGroup.ID;
webOrderRequestAction.ActionCode = subGroup.ActionCode;
webOrderRequestAction.Title = subGroup.Title;
webOrderRequestAction.Description = subGroup.Description;
webOrderRequestAction.Note = subGroup.Note;
webOrderRequestAction.ActionDate = subGroup.ActionDateTime;
webOrderRequestAction.CreatedByCooperatorName = subGroup.CreatedByCooperatorName;
webOrderRequestActionGroupViewModel.WebOrderRequestActions.Add(webOrderRequestAction);
}
viewModel.WebOrderRequestActionGroupViewModels.Add(webOrderRequestActionGroupViewModel);
}
}
catch (Exception ex)
{
Log.Error(ex, ex.Message);
}
return(viewModel);
}
public ResultContainer AddWebOrderRequestAction(WebOrderRequestAction webOrderRequestAction)
{
return(_webOrderRequestDAO.AddAction(webOrderRequestAction));
}
