public JsonResult SubmitFactor(string ABC) { var ModelSender = new ErrorReporterModel(); PDBC db = new PDBC(); List <ExcParameters> pas = new List <ExcParameters>(); tbl_Customer_Main tcm = new tbl_Customer_Main(); var coockie = HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerCode()); tcm = CoockieController.SayWhoIsHE(coockie.Value); FactorPopUpModel fpm = CoockieController.GetCustomerShopFactorCookie(HttpContext.Request.Cookies.Get(ProjectProperies.CustomerShoppingFactor()).Value); string DeleteAns = "خرید با موفقیت انجام شد!"; var c = new HttpCookie(ProjectProperies.CustomerShoppingFactor()); c.Expires = DateTime.Now.AddDays(-1); Response.Cookies.Add(c); var d = new HttpCookie(ProjectProperies.AuthCustomerShoppingBasket()); d.Expires = DateTime.Now.AddDays(-1); Response.Cookies.Add(d); AmountOfProductsLeft itemRemains = new AmountOfProductsLeft(); for (int i = 0; i < fpm.items.Count; i++) { if (itemRemains.CanBuyThisProductFromThisShop(fpm.items[i].Id.ToString(), "1", fpm.items[i].number) <= 0) { DeleteAns = "متاسفانه موجودی برخی کالا ها برای خرید شما کافی نمیباشد "; fpm.items.RemoveAt(i); } } if (fpm.items.Count == 0) { ModelSender = new ErrorReporterModel { ErrorID = "SX-fa3432", Errormessage = DeleteAns, Errortype = "Success" }; return(Json(ModelSender)); } Int64 totals = 0; for (int i = 0; i < fpm.items.Count; i++) { totals += fpm.items[i].total; } fpm.totality = totals.ToString(); ExcParameters pa = new ExcParameters() { _KEY = "@id_Customer", _VALUE = tcm.id_Customer }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@MainFactor_Code", _VALUE = "FM-" + DateTime.Now.Ticks }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@MainFactor_Price", _VALUE = fpm.totality }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@MainFactor_PaymentCode", _VALUE = "FMpc-" + DateTime.Now.Ticks }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@MainFactor_CreatorID", _VALUE = tcm.id_Customer }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@id_CAddress", _VALUE = "4003" }; pas.Add(pa); db.Connect(); string ReturnedID = db.Script("INSERT INTO [tbl_Factor_Main]([id_Customer],[MainFactor_Code],[MainFactor_Price],[MainFactor_IsPay],[MainFactor_PayMessage],[MainFactor_PaymentCode],[MainFactor_Tax],[MainFactor_TotalOff],[MainFactor_CreatedByUserType],[MainFactor_CreatorID],[MainFactor_ISEDITED],[MainFactor_EditedByAdminID],[MainFactor_EditedTo_id_MainFactor],[MainFactor_IsDeleted],[MainFactor_IsReturnedMoney],[MainFactor_PayType],[ChildFactor_DeleteTypeID],[id_CAddress]) output inserted.[id_MainFactor] VALUES(@id_Customer ,@MainFactor_Code ,@MainFactor_Price ,1,N'NOMessage',@MainFactor_PaymentCode,0,0,2,@MainFactor_CreatorID ,0,0,0,0,0,1,0,@id_CAddress )", pas); db.DC(); int idmf = 0; if (Int32.TryParse(ReturnedID, out idmf)) { string flag = ""; pas = new List <ExcParameters>(); string res = ""; db.Connect(); for (int i = 0; i < fpm.items.Count; i++) { pa = new ExcParameters() { _KEY = "@id_MainFactor", _VALUE = ReturnedID }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@ChildFactor_CreatorID", _VALUE = tcm.id_Customer }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@ChildFactor_ProductID", _VALUE = fpm.items[i].Id }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@ChildFactor_PurePrice", _VALUE = fpm.items[i].total }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@ChildFactor_PurePricee", _VALUE = fpm.items[i].total }; pas.Add(pa); pa = new ExcParameters() { _KEY = "@ChildFactor_QBuy", _VALUE = fpm.items[i].number }; pas.Add(pa); string idd = db.Script("INSERT INTO [tbl_Factor_ChildFactor]([id_MainFactor],[ChildFactor_DeleteTypeID],[ChildFactor_DeletedByAdminID],[ChildFactor_ISDELETED],[ChildFactor_CreateDate],[ChildFactor_CreatedByUserTypeID],[ChildFactor_CreatorID],[ChildFactor_ProductModuleType],[ChildFactor_ProductID],[ChildFactor_PastProductHistoryID],[ChildFactor_HasOff],[ChildFactor_OffID],[ChildFactor_OffCode],[ChildFactor_OffPrice],[ChildFactor_PurePrice],[ChildFactor_PriceAfterOff],[ChildFactor_ProductReturnTypeID],[ChildFactor_ISCERTIFIED],[ChildFactor_ISEDITED],[ChildFactor_EditedByAdminID],[ChildFactor_EditedTo_id_ChildFactor],[ChildFactor_QBuy]) OUTPUT inserted.[id_ChildFactor] VALUES(@id_MainFactor,0,0,0,GETDATE(),2,@ChildFactor_CreatorID ,1,@ChildFactor_ProductID ,0,0,0,N' ',0,@ChildFactor_PurePrice ,@ChildFactor_PurePricee,0,1,0,0,0,@ChildFactor_QBuy )", pas); res += db.Script("INSERT INTO [tbl_Factor_FactorInStock]([id_ChildFactor],[FactorInStock_FirstShopID],[FactorInStock_SecondShopID],[FactorInStock_CreatedDate],[FactorInStock_TransActionByAdminID],[FactorInStock_HasTransAction]) VALUES(" + idd + " ,1 ,0,GETDATE(),0,0)"); flag += "1"; } db.DC(); if (flag == res) { ModelSender = new ErrorReporterModel { ErrorID = "SX-fa3432", Errormessage = DeleteAns, Errortype = "Success" }; return(Json(ModelSender)); } else { ModelSender = new ErrorReporterModel { ErrorID = "EX15779455", Errormessage = $"خرید انجام نشد!", Errortype = "Error" }; return(Json(ModelSender)); } } else { ModelSender = new ErrorReporterModel { ErrorID = "EX785673455", Errormessage = $"خرید انجام نشد!!", Errortype = "Error" }; return(Json(ModelSender)); } }
public JsonResult ProductCountCalc(string QCount, string idmpc) { PDBC db = new PDBC(); db.Connect(); using (DataTable dt = db.Select("SELECT [Title],[MCName] ,[SCName],[PriceXquantity],[MultyPrice],[MultyPriceStartFromQ] FROM [v_Connector_MainProductConnectorToProduct] WHERE [id_MPC] = " + idmpc)) { db.DC(); var ModelSender = new ErrorReporterModel(); if (dt.Rows.Count == 0) { ModelSender = new ErrorReporterModel { ErrorID = "EX1153455", Errormessage = $"محصول یافت نشد!", Errortype = "Error" }; return(Json(ModelSender)); } else { if (Convert.ToInt32(QCount) > Convert.ToInt32(dt.Rows[0]["MultyPriceStartFromQ"].ToString())) { FactorPopUpModel fpm = CoockieController.GetCustomerShopFactorCookie(HttpContext.Request.Cookies.Get(ProjectProperies.CustomerShoppingFactor()).Value); for (int i = 0; i < fpm.items.Count; i++) { if (fpm.items[i].Id == Convert.ToInt32(idmpc)) { fpm.items[i].PriceXQ = Convert.ToInt64(dt.Rows[0]["MultyPrice"].ToString()); fpm.items[i].number = Convert.ToInt32(QCount); fpm.items[i].total = fpm.items[i].PriceXQ * fpm.items[i].number; break; } } Int64 totality = 0; for (int i = 0; i < fpm.items.Count; i++) { totality += fpm.items[i].total; } fpm.totality = totality.ToString(); ModelSender = new ErrorReporterModel { ErrorID = dt.Rows[0]["MultyPrice"].ToString(), Errormessage = $"", Errortype = "Success" }; var userCookieIDV = new HttpCookie(ProjectProperies.CustomerShoppingFactor()); userCookieIDV.Value = CoockieController.SetCustomerShopFactorCookie(fpm); userCookieIDV.Expires = DateTime.Now.AddDays(2); Response.SetCookie(userCookieIDV); return(Json(ModelSender)); } else { FactorPopUpModel fpm = CoockieController.GetCustomerShopFactorCookie(HttpContext.Request.Cookies.Get(ProjectProperies.CustomerShoppingFactor()).Value); for (int i = 0; i < fpm.items.Count; i++) { if (fpm.items[i].Id == Convert.ToInt32(idmpc)) { fpm.items[i].PriceXQ = Convert.ToInt64(dt.Rows[0]["PriceXquantity"].ToString()); fpm.items[i].number = Convert.ToInt32(QCount); fpm.items[i].total = fpm.items[i].PriceXQ * fpm.items[i].number; break; } } Int64 totality = 0; for (int i = 0; i < fpm.items.Count; i++) { totality += fpm.items[i].total; } fpm.totality = totality.ToString(); var userCookieIDV = new HttpCookie(ProjectProperies.CustomerShoppingFactor()); userCookieIDV.Value = CoockieController.SetCustomerShopFactorCookie(fpm); userCookieIDV.Expires = DateTime.Now.AddDays(2); Response.SetCookie(userCookieIDV); ModelSender = new ErrorReporterModel { ErrorID = dt.Rows[0]["PriceXquantity"].ToString(), Errormessage = $"", Errortype = "Success" }; return(Json(ModelSender)); } } } }