public ActionResult update(int id, DateTime date, int quantity, int price, string orderStatus, int orderProductStoreID, int productID)
{
try
{
OrderProductDetails orderProductDetails = _orderProductDetailsService.Get(_ => _.Id == id);
if (orderProductDetails == null)
{
throw new Exception();
}
orderProductDetails.Date = date;
orderProductDetails.Quantity = quantity;
orderProductDetails.Price = price;
orderProductDetails.OrderStatus = orderStatus;
orderProductDetails.OrderProductStoreId = orderProductStoreID;
orderProductDetails.ProductId = productID;
_orderProductDetailsService.Update(orderProductDetails);
_orderProductDetailsService.SaveChanges();
return(StatusCode(204));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
private List <OrderProductDetails> GetProductList(SqlDataReader dataReader)
{
List <OrderProductDetails> lstDCRProductsDetails = new List <OrderProductDetails>();
while (dataReader.Read())
{
OrderProductDetails dcrProductsDetailsModel = new OrderProductDetails();
if (dataReader["Product_Name"] != DBNull.Value)
{
dcrProductsDetailsModel.label = dataReader["Product_Name"].ToString();
}
if (dataReader["Product_Code"] != DBNull.Value)
{
dcrProductsDetailsModel.value = dataReader["Product_Code"].ToString();
}
if (dataReader["Unit_Rate"] != DBNull.Value)
{
dcrProductsDetailsModel.Unit_Rate = Convert.ToDecimal(dataReader["Unit_Rate"].ToString());
}
if (dataReader["Price_group_Code"] != DBNull.Value)
{
dcrProductsDetailsModel.Price_group_Code = dataReader["Price_group_Code"].ToString();
}
lstDCRProductsDetails.Add(dcrProductsDetailsModel);
}
return(lstDCRProductsDetails);
}
public ViewResult ListMaximumSoldProductSelected(int id)
{
OrderProductDetails order = orderOperationsBusinessLogic.
GetAllOrderFromProductSoldMaximum(id);
return(View(order));
}
/// <summary>
/// DoCheckout is called when the customer checks out.
/// </summary>
// public virtual void DoCheckout()
// {
// Override DoCheckout if you need to execute a specific action only when the customer checks out (such as actions you want to perform only after the customer was billed).
// Otherwise you can leave this method empty.
// }
/// <summary>
/// Duplicates the Recipient List selection of one Order Product to another when reordering an Order Product
/// </summary>
public override ValidationResult Reorder(OrderProductDetails oldOrderProduct, OrderProductDetails newOrderProduct)
{
ValidationResult vr = new ValidationResult(true);
// Add special logic which is required in order to duplicate the recipient list.
// If such logic is not required (as in case of this sample), there is no need to override this method.
return(vr);
}
public ActionResult getOrderProductDetail(int id)
{
try
{
OrderProductDetails orderProductDetails = _orderProductDetailsService.Get(_ => _.Id == id);
return(Ok(orderProductDetails));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult create(DateTime date, int quantity, int price, string orderStatus, int orderProductStoreID, int productID)
{
try
{
OrderProductDetails orderProductDetails = new OrderProductDetails
{
Date = date,
Quantity = quantity,
Price = price,
OrderStatus = orderStatus,
OrderProductStoreId = orderProductStoreID,
ProductId = productID
};
_orderProductDetailsService.Add(orderProductDetails);
_orderProductDetailsService.SaveChanges();
return(Ok(orderProductDetails.Id));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public string AddOrderProductDetail(OrderDetailsViewModel objOrderDetailsViewModel)
{
var i = 0;
try
{
//get mobileNumber from user table
string mobileNumber = objOrderDetailsViewModel.Retailer_Mobile;
var number = (from user in dbContext.UserInfo where user.MobileNumber == mobileNumber select user).FirstOrDefault();
if (number != null)
{
OrderProductDetails objOrderProductDetails = new OrderProductDetails();
var getcsvfile = objOrderDetailsViewModel.csvfile.Table1;
foreach (var j in getcsvfile)
{
objOrderProductDetails.order_id = Convert.ToInt32(objOrderDetailsViewModel.Order_Id);
objOrderProductDetails.product_id = j.product_Id;
objOrderProductDetails.qty = j.OrderQuantity;
objOrderProductDetails.price = j.price;
objOrderProductDetails.tr_date = DateTime.Now;
objOrderProductDetails.SAP_order_ID = objOrderDetailsViewModel.SAP_Order_ID;
dbContext.OrderProductDetails.Add(objOrderProductDetails);
i = dbContext.SaveChanges();
}
//objOrderProductDetails.product_id = "115001003CBE17";
//objOrderProductDetails.qty = "60";
//objOrderProductDetails.price = "410";
if (i != 0)
{
objResponse.Message = objOrderDetailsViewModel.Totalprice;
return(objResponse.Message);
}
else
{
objResponse.Message = "Failed";
return(objResponse.Message);
}
}
else
{
objResponse.Message = "Mobile number not exists.";
return(objResponse.Message);
}
}
catch (Exception ex)
{
Log.Info(Convert.ToString(ex.InnerException));
Log.Info(ex.Message);
OrderErrorLogDetails objOrderErrorLogDetails = new OrderErrorLogDetails();
objOrderErrorLogDetails.Retailer_Id = objOrderDetailsViewModel.Retailer_Id;
objOrderErrorLogDetails.Retailer_Mobile = objOrderDetailsViewModel.Retailer_Mobile;
objOrderErrorLogDetails.PaymentMode = objOrderDetailsViewModel.Payment_Mode;
objOrderErrorLogDetails.Total_Price = objOrderDetailsViewModel.Totalprice;
objOrderErrorLogDetails.Qty = objOrderDetailsViewModel.Qty;
objOrderErrorLogDetails.Csv_File = JsonConvert.SerializeObject(objOrderDetailsViewModel.csvfile.Table1);
objOrderErrorLogDetails.Error_Msg = ex.Message;
objOrderErrorLogDetails.Tr_Date = DateTime.Now;
dbContext.OrderErrorLogDetails.Add(objOrderErrorLogDetails);
i = dbContext.SaveChanges();
if (i != 0)
{
objResponse.Message = "Exception Logged Successfully";
return(objResponse.Message);
}
else
{
objResponse.Message = "Failed to Log Exception";
return(objResponse.Message);
}
// objCommonClasses.InsertExceptionDetails(ex, "UserController", "AddOrderProductDetail");
// return ex.Message;
}
}
