public TableResponse <TableReturn> DeleteRequest(string requestNo) { var requestTransaction = new RequestHeaderDto { RequestNo = requestNo, RequestDetails = new List <RequestDetailDto>() }; return(SaveRequest(requestTransaction, TransactionTypes.Delete.ToString())); }
public ActionResult UpdateRequest(RequestHeaderDto request) { var response = _requestRepository.UpdateRequest(request); if (response.OutList != null && response.OutList.Count() > 0) { return(new JsonErrorResult(response, HttpStatusCode.PartialContent)); } else if (response.Ok) { return(Ok(response)); } else { return(new JsonErrorResult(new { Message = response.Message }, HttpStatusCode.InternalServerError)); } }
private TableResponse <TableReturn> SaveRequest(RequestHeaderDto requestTransaction, string transcationType) { #region Sql Parameter loading List <SqlParameter> parms = new List <SqlParameter> { new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[0].ToString(), Value = requestTransaction.RequestNo.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[1].ToString(), Value = requestTransaction.CustomerCode.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[2].ToString(), Value = requestTransaction.DeliveryDate.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[3].ToString(), Value = requestTransaction.OrderReceivedBy.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[4].ToString(), Value = requestTransaction.Remarks.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[5].ToString(), Value = requestTransaction.AuthorizedOfficerId.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[6].ToString(), Value = requestTransaction.CartonCount.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[7].ToString(), Value = requestTransaction.RequestType.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[8].ToString(), Value = requestTransaction.UserId.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[9].ToString(), Value = requestTransaction.Status.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[10].ToString(), Value = requestTransaction.ServiceTypeId.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[11].ToString(), Value = requestTransaction.WorkOrderType.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[12].ToString(), Value = requestTransaction.ContactPersonName.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[13].ToString(), Value = requestTransaction.DeliveryLocation.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[14].ToString(), Value = requestTransaction.DeliveryRouteId.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[15].ToString(), Value = transcationType.AsDbValue() }, new SqlParameter { ParameterName = RequestStoredProcedure.StoredProcedureParameters[16].ToString(), TypeName = RequestStoredProcedure.StoredProcedureTypeNames[0].ToString(), SqlDbType = SqlDbType.Structured, Value = requestTransaction.RequestDetails.ToList().ToDataTable() }, }; #endregion var resultTable = _tcContext.Set <TableReturn>().FromSqlRaw(RequestStoredProcedure.Sql, parms.ToArray()).ToList(); var tableResponse = new TableResponse <TableReturn> { Message = resultTable.Where(x => x.Reason == "OK" || x.Reason == "NOK").FirstOrDefault().OutValue, Ok = resultTable.Where(x => x.Reason == "OK").FirstOrDefault() != null ? true : false, OutList = resultTable.Where(x => x.Reason != "OK" && x.Reason != "NOK").ToList() }; return(tableResponse); }
public TableResponse <TableReturn> UpdateRequest(RequestHeaderDto requestUpdate) { return(SaveRequest(requestUpdate, TransactionTypes.Update.ToString())); }
public TableResponse <TableReturn> AddRequest(RequestHeaderDto requestInsert) { return(SaveRequest(requestInsert, TransactionTypes.Insert.ToString())); }
public ActionResult DeleteRequest(RequestHeaderDto request) { return(Ok(_requestRepository.DeleteRequest(request.RequestNo))); }