public bool UpdateStatusOrder(OuikumOrderDetail orDetial) { using (var trans = new TransactionScope()) { string sqlUpdate = "StatusProduct = '" + orDetial.StatusProduct + "'"; string sqlWhere = "OrDetailID = " + orDetial.OrDetailID + " AND ProductID = " + orDetial.ProductID; UpdateByCondition <OuikumOrderDetail>(sqlUpdate, sqlWhere); trans.Complete(); IsResult = true; } return(IsResult); }
public ActionResult SaveStatus(string OrDetailCode, string StatusProduct) { OuikumOrderDetail orDetial = new OuikumOrderDetail(); var svOrderPur = new OrderPurchaseService(); var svOrderStauts = new OrderStatusService(); string SQLWhere = string.Empty; try { var GetorderDetail = svOrderPur.SelectData <View_OuikumOrderDetailSC>("OrDetailID,OrDetailcode,ProductID,ProductName,StatusProduct", "IsDelete = 0 AND OrDetailCode = '" + OrDetailCode + "'").First(); SQLWhere = svOrderStauts.CreateWhereAction(OrderStatusAction.ConfirmBySC, LogonCompID); var Status = svOrderPur.SelectData <OuikumStausOrder>("NameStatus", SQLWhere, "NameStatus", 1, 0); orDetial.OrDetailID = GetorderDetail.OrDetailID; if (GetorderDetail.StatusProduct == "A") { orDetial.StatusProduct = "B"; } else if (GetorderDetail.StatusProduct == "B") { orDetial.StatusProduct = "C"; } else { orDetial.StatusProduct = "D"; } orDetial.ProductID = GetorderDetail.ProductID; orDetial.ModifiedDate = DateTime.Now; #region Update Satatus OrderDetail svOrderPur.UpdateStatusOrder(orDetial); #endregion } catch (Exception ex) { return(Json(new { IsSuccess = false })); } return(Json(new { IsSuccess = true })); }
public ActionResult AddOrderProduct(FormCollection form) { OuikumOrder tOrder = new OuikumOrder(); OuikumOrderDetail tOrderDetail = new OuikumOrderDetail(); var svCart = new CartService(); var svShipment = new ShipmentService(); #region set Order tOrder.SendName = form["SendName"]; tOrder.SendSername = form["SendSername"]; tOrder.SendTel = form["SendTel"]; tOrder.Email = form["Email"]; if (form["AddrLine1"] != null) { tOrder.AddrLine1 = form["AddrLine1"]; } if (form["AddrLine2"] != null) { tOrder.AddrLine2 = form["AddrLine2"]; } tOrder.SubDirtrict = form["SubDirtrict"]; tOrder.DirtrictID = Convert.ToInt32(form["DirtrictID"]); tOrder.ProviceID = Convert.ToInt32(form["ProviceID"]); tOrder.Postal = form["Postal"]; tOrder.CompID = LogonCompID; tOrder.OrderStatus = "A"; tOrder.Total = Convert.ToDecimal(form["Total"]); tOrder.RowFlag = 1; tOrder.RowVersion = 1; tOrder.IsDelete = false; tOrder.IsShow = true; tOrder.OrderDate = DateTime.Now; tOrder.CreatedDate = DateTime.Now; tOrder.ModifiedDate = DateTime.Now; tOrder.CreatedBy = Convert.ToString(LogonCompID); tOrder.ModifiedBy = Convert.ToString(LogonCompID); #endregion var getTempCart = svCart.SelectData <View_TempCart>("*", "IsDelete = 0 and TempIDLogon = " + LogonCompID); var OrderNumber = 1; var TempOrderDetail = new List <OuikumOrderDetail>(); var ShipmentProduct = svShipment.SelectData <View_ShipmentProduct>("*", "IsDelete = 0 and TempIDLogon = " + LogonCompID); ViewBag.ShipmentProduct = ShipmentProduct; if (getTempCart.Count > 0) { for (int i = 0; i <= getTempCart.Count - 1; i++) { decimal?TotalPriceProduct = 0; #region set OrderDetail var detail = new OuikumOrderDetail(); detail.ProductID = getTempCart[i].TempProdcutID; detail.CompSCID = getTempCart[i].CompID; detail.Qty = getTempCart[i].TempCountProduct; detail.Qty_Price = getTempCart[i].TempPrice; foreach (var getShipmentPrice in (List <View_ShipmentProduct>)ViewBag.ShipmentProduct) { if (getShipmentPrice.CompID == getTempCart[i].CompID && getShipmentPrice.ProductID == getTempCart[i].TempProdcutID) { if (getTempCart[i].TempCountProduct <= getShipmentPrice.BuyMaximum && getTempCart[i].TempCountProduct >= getShipmentPrice.BuyMinimum) { detail.PriceShipment = getShipmentPrice.PriceShipment; TotalPriceProduct = getShipmentPrice.PriceShipment; } } } var SumPriceUnit1 = getTempCart[i].TempCountProduct * getTempCart[i].TempPrice; detail.TotalPriceproduct = SumPriceUnit1; detail.TotalSum = SumPriceUnit1 + TotalPriceProduct; detail.StatusProduct = "A"; detail.OrDetailCode = AutoGenCode("Or-D", OrderNumber); detail.IsShow = true; detail.IsDelete = false; detail.RowFlag = 1; detail.RowVersion = 1; detail.CreatedDate = DateTime.Now; detail.ModifiedDate = DateTime.Now; detail.CreatedBy = Convert.ToString(LogonCompID); detail.ModifiedBy = Convert.ToString(LogonCompID); OrderNumber++; TempOrderDetail.Add(detail); TotalPriceProduct = 0; #endregion } #region Insert b2bOrder svCart.InsertOrder(tOrder, TempOrderDetail); #endregion } UpdateTempCart(); if (svCart.IsResult) { var compBuyer = svCompany.SelectData <View_getSendmailOrder>("Email, namebuyer , CompID ,OrderID", " OrderID = " + tOrder.OrderID, null).First(); if (!SendEmailOrdertoBuyer(compBuyer.namebuyer, compBuyer.Email, compBuyer.OrderID)) { return(Json(new { IsSuccess = false, Result = res.EmaiOrderToBuyer.lblresulttobuyerfalse })); } else { //return Json(new { IsSuccess = true, Result = res.EmaiOrderToBuyer.lblresulttobuyer }); var compSeller = svCompany.SelectDataEmailtoSeller <view_getMailOrdertoSeller>(" emailseller, OrderID, compidseller ", " OrderID = " + tOrder.OrderID); var Mailseller = new List <view_getMailOrdertoSeller>(); if (compSeller.Count > 0) { for (int a = 0; a <= compSeller.Count - 1; a++) { var email = new view_getMailOrdertoSeller(); email.emailseller = compSeller[a].emailseller; email.OrderID = compSeller[a].OrderID; email.compidseller = compSeller[a].compidseller; Mailseller.Add(email); } if (!SendEmailOrdertoSeller(Mailseller, tOrder.OrderID)) { return(Json(new { IsSuccess = false, Result = res.EmaiOrderToBuyer.lblresulttobuyerfalse })); } else { return(Json(new { IsSuccess = true, Result = res.EmaiOrderToBuyer.lblresulttobuyer })); } } } } return(Json(new { IsSuccess = true, Result = "บันทึกรายการสั่งซื้อของคุณเรียบร้อยแล้ว" })); // return svCart.IsResult; }