public ActionResult ProductInStockpile(int PSID) { ProductInStockpileModelView model = new ProductInStockpileModelView(); PDBC db = new PDBC(); ExcParameters par = new ExcParameters() { _KEY = "@id_MPC", _VALUE = PSID }; List <ExcParameters> pars = new List <ExcParameters>(); pars.Add(par); string id_MProductReal = ""; db.Connect(); using (DataTable dtproduct = db.Select("SELECT [MoneyTypeName],[PQT_Demansion], [id_MProduct],[MultyPriceStartFromQ],[code_Stockpile],[Description],[MultyPrice],[Title],[PricePerquantity] FROM [v_Connector_MainProductConnectorToProduct] WHERE [id_MPC] = @id_MPC", pars)) { db.DC(); if (dtproduct.Rows.Count > 0) { id_MProductReal = dtproduct.Rows[0]["id_MProduct"].ToString(); model.ShowPSIDs = new ShowPSID() { id_MPC = PSID.ToString(), MultyPriceStartFromQ = dtproduct.Rows[0]["MultyPriceStartFromQ"].ToString(), PicList = new List <string>(), ProductCode = dtproduct.Rows[0]["code_Stockpile"].ToString(), ProductDescription = dtproduct.Rows[0]["Description"].ToString(), ProductMultyPrice = dtproduct.Rows[0]["MultyPrice"].ToString(), ProductName = dtproduct.Rows[0]["Title"].ToString(), ProductPurePrice = dtproduct.Rows[0]["PricePerquantity"].ToString(), ShopAvailable4Transaction = new List <Key_ValueModel>(), ShopList = new List <Shops>(), socKandSockvlList = new List <ProductViewDetails_ProductSOCKandSOCKVLList>(), STHList = new List <StockpileTransactionHistoryModel>(), MoneyType = dtproduct.Rows[0]["MoneyTypeName"].ToString(), demansion = dtproduct.Rows[0]["PQT_Demansion"].ToString(), }; } else { return(RedirectToAction("Index")); } } //===========================pics db.Connect(); using (DataTable dt = db.Select("SELECT [orgUploadAddress] FROM [v_tblProduct_Image] WHERE [id_MProduct]=" + id_MProductReal)) { db.DC(); int dtrows = dt.Rows.Count; for (int i = 0; i < dtrows; i++) { model.ShowPSIDs.PicList.Add(dt.Rows[i]["orgUploadAddress"].ToString()); } } if (model.ShowPSIDs.PicList.Count == 0) { model.ShowPSIDs.PicList.Add("/AdminDesignResource/app/media/img/users/user4.jpg"); } //==============================Shops db.Connect(); using (DataTable dtstock = db.Select("SELECT [id_Stockpile] ,[id_Stockpile_AllowType] ,[shop_id] ,[shop_name] ,[shop_IsAvailable] ,[shop_IsDelete] FROM [v_Stockpile_MainView] WHERE [id_MPC] = " + PSID)) { db.DC(); AmountOfProductsLeft AOPL = new AmountOfProductsLeft(); for (int i = 0; i < dtstock.Rows.Count; i++) { bool CalCulatingFromShops = false; if (dtstock.Rows[i]["id_Stockpile_AllowType"].ToString() == "1") { CalCulatingFromShops = true; } bool ISActivate = false; if (dtstock.Rows[i]["shop_IsDelete"].ToString() == "0" && dtstock.Rows[i]["shop_IsAvailable"].ToString() == "1") { ISActivate = true; } //ProductCALCULATOR Int64 ProductAvailableCount = AOPL.CanBuyThisProductFromThisShop(PSID.ToString(), dtstock.Rows[i]["shop_id"].ToString(), -1); string BootstrapColor = ""; if (ProductAvailableCount > 200) { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.success); } else if (ProductAvailableCount > 100) { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.warning); } else { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.danger); } model.ShowPSIDs.ShopList.Add(new Shops() { ShopName = dtstock.Rows[i]["shop_name"].ToString(), CalCulatingFromShop = CalCulatingFromShops, ISActivate = ISActivate, ProductAvailableCount = String.Format("{0:n0}", ProductAvailableCount), BootstrapColor = BootstrapColor }); } } //===================================socKandSockvlList db.Connect(); using (DataTable dtproduct = db.Select("SELECT [PTname], [MCName],[SCName] FROM [v_Connector_MainProductConnectorToProduct] WHERE [id_MPC] = " + PSID)) { using (DataTable dt = db.Select("SELECT [id_MPC] ,[SCOKName] ,[SCOVValueName] FROM [v_ConnectorTheProductConnectorViewToSCOVandSCOKV_s] WHERE [id_MProduct] = " + id_MProductReal + " ORDER BY [id_MPC] DESC")) { db.DC(); if (dt.Rows.Count > 0) { int dtrows = dt.Rows.Count; ProductViewDetails_ProductSOCKandSOCKVLList products = new ProductViewDetails_ProductSOCKandSOCKVLList(); products.ProductSOCKSOCKVList = new List <ProductViewDetails_ProductSOCKandSOCKVL>(); string id_MPC = ""; products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.primary), SOCKName = "سردسته بندی اصلی", SOCKVName = dtproduct.Rows[0]["PTname"].ToString() }); products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.primary), SOCKName = "گروه اصلی", SOCKVName = dtproduct.Rows[0]["MCName"].ToString() }); products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.primary), SOCKName = "گروه محصول", SOCKVName = dtproduct.Rows[0]["SCName"].ToString() }); for (int i = 0; i < dtrows; i++) { if (id_MPC != dt.Rows[i]["id_MPC"].ToString()) { if (!string.IsNullOrEmpty(id_MPC)) { products.id_MPC = id_MPC; model.ShowPSIDs.socKandSockvlList.Add(products); products = new ProductViewDetails_ProductSOCKandSOCKVLList(); products.ProductSOCKSOCKVList = new List <ProductViewDetails_ProductSOCKandSOCKVL>(); products.id_MPC = dt.Rows[i]["id_MPC"].ToString(); products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.primary), SOCKName = "سردسته بندی اصلی", SOCKVName = dtproduct.Rows[0]["PTname"].ToString() }); products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.primary), SOCKName = "گروه اصلی", SOCKVName = dtproduct.Rows[0]["MCName"].ToString() }); products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.primary), SOCKName = "گروه محصول", SOCKVName = dtproduct.Rows[0]["SCName"].ToString() }); } } products.ProductSOCKSOCKVList.Add(new ProductViewDetails_ProductSOCKandSOCKVL() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorRandomByCounter(i), SOCKName = dt.Rows[i]["SCOKName"].ToString(), SOCKVName = dt.Rows[i]["SCOVValueName"].ToString() }); id_MPC = dt.Rows[i]["id_MPC"].ToString(); if (i == dtrows - 1) { products.id_MPC = id_MPC; model.ShowPSIDs.socKandSockvlList.Add(products); } } } else { return(RedirectToAction("index")); } } } //=-=======================================StockpileTransactionHistoryModel db.Connect(); using (DataTable dt = db.Select("SELECT [shop_id], [id_TransactionType], [PQT_Demansion],[PQTValueOf_Transaction],[PriceOf_Transaction],[shop_name],[StockpileDate_Transaction],[StockpileTime_Transaction],[MoneyTypeName] FROM [v_Stockpile_Transactions] WHERE [id_MPC] = " + PSID + " ORDER BY [id_Transaction] DESC")) { db.DC(); int dtcount = dt.Rows.Count; if (dtcount > 0) { for (int i = 0; i < dtcount; i++) { StockpileTransactionHistoryModel historyModel = new StockpileTransactionHistoryModel(); // { // BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.danger), // Dimension = "موردی یافت نشد", // HajmSadere = "موردی یافت نشد",x // HajmVarede = "موردی یافت نشد",x // MiyanginGheymateSadere = "موردی یافت نشد"x //, // MiyanginGheymateVarede = "موردی یافت نشد",x // Mojoodi = "موردی یافت نشد",x // ShopID = "موردی یافت نشد",x // ShopName = "موردی یافت نشد",x // TotalPriceOfsadere = "موردی یافت نشد",x // TotalPriceOfVarede = "موردی یافت نشد",x // TransActionDate = "موردی یافت نشد",x // }; historyModel.ShopID = dt.Rows[i]["shop_id"].ToString(); historyModel.ShopName = dt.Rows[i]["shop_name"].ToString(); historyModel.Mojoodi = "0"; PersianDateTime pdt = new PersianDateTime(DateTime.Parse(dt.Rows[i]["StockpileDate_Transaction"].ToString())); historyModel.TransActionDate = pdt.ToLongDateString() + " " + dt.Rows[i]["StockpileTime_Transaction"].ToString(); historyModel.Dimension = dt.Rows[i]["PQT_Demansion"].ToString(); if (dt.Rows[i]["id_TransactionType"].ToString() == "1") { historyModel.BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.success); historyModel.HajmSadere = "0"; historyModel.MiyanginGheymateSadere = "0"; historyModel.TotalPriceOfsadere = "0"; historyModel.HajmVarede = String.Format("{0:n0}", dt.Rows[i]["PQTValueOf_Transaction"].ToString()); historyModel.MiyanginGheymateVarede = "0"; historyModel.TotalPriceOfVarede = String.Format("{0:n0}", dt.Rows[i]["PriceOf_Transaction"].ToString()) + " " + dt.Rows[i]["PQT_Demansion"].ToString(); } else { historyModel.BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.danger); historyModel.HajmVarede = "0"; historyModel.MiyanginGheymateVarede = "0"; historyModel.TotalPriceOfVarede = "0"; historyModel.HajmSadere = String.Format("{0:n0}", dt.Rows[i]["PQTValueOf_Transaction"].ToString()); historyModel.MiyanginGheymateSadere = "0"; historyModel.TotalPriceOfsadere = String.Format("{0:n0}", dt.Rows[i]["PriceOf_Transaction"].ToString()) + " " + dt.Rows[i]["PQT_Demansion"].ToString(); } model.ShowPSIDs.STHList.Add(historyModel); } } else { StockpileTransactionHistoryModel historyModel = new StockpileTransactionHistoryModel() { BootstrapColor = BootstrapColorPicker.GetbootstrapColorByTag(BootstrapColorEnums.danger), Dimension = "موردی یافت نشد", HajmSadere = "موردی یافت نشد", HajmVarede = "موردی یافت نشد", MiyanginGheymateSadere = "موردی یافت نشد" , MiyanginGheymateVarede = "موردی یافت نشد", Mojoodi = "موردی یافت نشد", ShopID = "موردی یافت نشد", ShopName = "موردی یافت نشد", TotalPriceOfsadere = "موردی یافت نشد", TotalPriceOfVarede = "موردی یافت نشد", TransActionDate = "موردی یافت نشد", }; model.ShowPSIDs.STHList.Add(historyModel); } } //================================================ ShopAvailable4Transaction //=================>MRMNeedsEdit db.Connect(); using (DataTable shops = db.Select("SELECT [shop_id] ,[shop_name] FROM [tbl_Modules_StockpileShopsMainTable]")) { db.DC(); Key_ValueModel kvm; for (int i = 0; i < shops.Rows.Count; i++) { kvm = new Key_ValueModel() { Id = Convert.ToInt32(shops.Rows[i]["shop_id"].ToString()), Value = shops.Rows[i]["shop_name"].ToString() }; model.ShowPSIDs.ShopAvailable4Transaction.Add(kvm); } } return(View(model)); }
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)); } }