public ActionResult customerProfileHistory()
{
historyProductItemsModelView model = new historyProductItemsModelView()
{
History = new List <historyProductCardItemsModel>()
};
tbl_Customer_Main tcm = new tbl_Customer_Main();
if (HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerCode()) != null)
{
var coockie = HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerCode());
tcm = CoockieController.SayWhoIsHE(coockie.Value);
}
else
{
return(RedirectToAction("loginandregister", "CustomerSide_Register"));
}
PDBC db = new PDBC();
db.Connect();
using (DataTable dt = db.Select("SELECT [id_MainFactor],[MainFactor_CreateDate],[MainFactor_Code],[MainFactor_Price],[MainFactor_IsPay],[MainFactor_Tax],[MainFactor_TotalOff],[PayType] FROM [v_Factor_Main] WHERE [id_Customer] = " + tcm.id_Customer))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
using (DataTable dt2 = db.Select("SELECT [id_MPC],[id_MainFactor],[id_ChildFactor],[Title],[MoneyTypeName],[PQT_Demansion],[ChildFactor_PurePrice],[ChildFactor_QBuy],[MultyPriceStartFromQ],[MultyPrice],[PriceXquantity] FROM [v_ChildFactorToProduct] WHERE [id_MainFactor] = " + dt.Rows[i]["id_MainFactor"].ToString()))
{
db.DC();
historyProductCardItemsModel df = new historyProductCardItemsModel()
{
WhenCreated = new PersianDateTime(DateTime.Parse(dt.Rows[i]["MainFactor_CreateDate"].ToString())).ToLongDateTimeString(),
Ispay = (dt.Rows[i]["MainFactor_IsPay"].ToString()),
OffPrice = 0,
PeygiriCode = dt.Rows[i]["MainFactor_Code"].ToString(),
TaxPrice = 0,
PayMentTypeName = dt.Rows[i]["PayType"].ToString(),
PayPrice = Convert.ToInt64(dt.Rows[i]["MainFactor_Price"].ToString()),
TotalPrice = Convert.ToInt64(dt.Rows[i]["MainFactor_Price"].ToString())
};
df.AllItems = new List <historyProductTableItemsModel>();
for (int j = 0; j < dt2.Rows.Count; j++)
{
historyProductTableItemsModel ai = new historyProductTableItemsModel()
{
Countof = dt2.Rows[j]["ChildFactor_QBuy"].ToString(),
id_MPC = dt2.Rows[j]["id_MPC"].ToString(),
ProductDimensionName = dt2.Rows[j]["PQT_Demansion"].ToString(),
ProductName = dt2.Rows[j]["Title"].ToString(),
scoknameandvalue = "",
ImagePath = UploaderGeneral.imageFinderfromIDMPC(dt2.Rows[j]["id_MPC"].ToString(), ImageSizeEnums.Thumbnail),
};
if (Convert.ToInt64(dt2.Rows[j]["ChildFactor_QBuy"].ToString()) > Convert.ToInt64(dt2.Rows[j]["MultyPriceStartFromQ"].ToString()))
{
ai.pricebperQ = dt2.Rows[j]["MultyPrice"].ToString();
ai.TotalPrice = (Convert.ToInt64(ai.pricebperQ) * Convert.ToInt64(dt2.Rows[j]["ChildFactor_QBuy"].ToString())).ToString();
}
else
{
ai.pricebperQ = dt2.Rows[j]["PriceXquantity"].ToString();
ai.TotalPrice = (Convert.ToInt64(ai.pricebperQ) * Convert.ToInt64(dt2.Rows[j]["ChildFactor_QBuy"].ToString())).ToString();
}
df.AllItems.Add(ai);
}
model.History.Add(df);
db.Connect();
}
}
db.DC();
}
return(View(model));
}
public JsonResult AddproductToBasket(string idp, string Number_inp)
{
var ModelSender = new ErrorReporterModel();
if (string.IsNullOrEmpty(Number_inp) || Convert.ToInt32(Number_inp) < 1)
{
ModelSender = new ErrorReporterModel
{
ErrorID = "EX186763",
Errormessage = $"تعداد محصول خریداری شده معتبر نمیباشد!",
Errortype = "Error"
};
return(Json(ModelSender));
}
PDBC db = new PDBC();
tbl_Customer_Main tcm = new tbl_Customer_Main();
var coockie = HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerCode());
if (coockie != null)
{
tcm = CoockieController.SayWhoIsHE(coockie.Value);
}
else
{
ModelSender = new ErrorReporterModel
{
ErrorID = "EX186763",
Errormessage = $"ابتدا وارد اکانت کاربری خود شوید!",
Errortype = "Error"
};
return(Json(ModelSender));
}
var coockie2 = HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerShoppingBasket());
if (coockie2 != null)
{
var coockie3 = JsonConvert.DeserializeObject <ShoppingBasket>(HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerShoppingBasket()).Value);
var KK = coockie3.Items.Find(x => x.idmpc == idp);
if (KK != null)
{
coockie3.Items.Remove(KK);
}
List <ExcParameters> pars = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@id_MPC",
_VALUE = idp
};
pars.Add(par);
db.Connect();
using (DataTable dt = db.Select("SELECT [Quantity],[Title] ,[PriceXquantity] ,[PricePerquantity] ,[MultyPriceStartFromQ] ,[MultyPrice] FROM [v_Connector_MainProductConnectorToProduct] WHERE [id_MPC] = @id_MPC AND [tlb_Product_MainProductConnector_ISDELETE] = 0 ", pars))
{
db.DC();
if (dt.Rows.Count > 0)
{
ShoppingBasketItems ssd = new ShoppingBasketItems()
{
idmpc = idp,
CountOf = Convert.ToInt32(Number_inp),
ImagePath = UploaderGeneral.imageFinderfromIDMPC(idp, ImageSizeEnums.Thumbnail),
Title = dt.Rows[0]["Title"].ToString()
};
int assd = Convert.ToInt32(dt.Rows[0]["MultyPriceStartFromQ"].ToString());
if (Convert.ToInt32(dt.Rows[0]["MultyPriceStartFromQ"].ToString()) < Convert.ToInt32(Number_inp))
{
ssd.PriceXQ = Convert.ToInt64(dt.Rows[0]["MultyPrice"].ToString());
}
else
{
ssd.PriceXQ = Convert.ToInt64(dt.Rows[0]["PriceXquantity"].ToString());
}
ssd.Totals = ssd.PriceXQ * ssd.CountOf;
coockie3.Items.Add(ssd);
}
else
{
ModelSender = new ErrorReporterModel
{
ErrorID = "EX567763",
Errormessage = $"محصول یافت نشد!",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
var userCookieIDV = new HttpCookie(ProjectProperies.AuthCustomerShoppingBasket());
userCookieIDV.Value = JsonConvert.SerializeObject(coockie3);
userCookieIDV.Expires = DateTime.Now.AddDays(2);
Response.SetCookie(userCookieIDV);
ModelSender = new ErrorReporterModel
{
ErrorID = "SX106",
Errormessage = $"با موفقیت افزوده شد!",
Errortype = "Success"
};
return(Json(ModelSender));
}
else
{
ShoppingBasket SB = new ShoppingBasket()
{
Items = new List <ShoppingBasketItems>()
};
List <ExcParameters> pars = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@id_MPC",
_VALUE = idp
};
pars.Add(par);
db.Connect();
using (DataTable dt = db.Select("SELECT [Quantity] ,[Title],[PriceXquantity] ,[PricePerquantity] ,[MultyPriceStartFromQ] ,[MultyPrice] FROM [v_Connector_MainProductConnectorToProduct] WHERE [id_MPC] = @id_MPC AND [tlb_Product_MainProductConnector_ISDELETE] = 0 ", pars))
{
db.DC();
if (dt.Rows.Count > 0)
{
ShoppingBasketItems ssd = new ShoppingBasketItems()
{
idmpc = idp,
CountOf = Convert.ToInt32(Number_inp),
ImagePath = UploaderGeneral.imageFinderfromIDMPC(idp, ImageSizeEnums.Thumbnail),
Title = dt.Rows[0]["Title"].ToString()
};
if (Convert.ToInt32(dt.Rows[0]["MultyPriceStartFromQ"].ToString()) < Convert.ToInt32(Number_inp))
{
ssd.PriceXQ = Convert.ToInt64(dt.Rows[0]["MultyPrice"].ToString());
}
else
{
ssd.PriceXQ = Convert.ToInt64(dt.Rows[0]["PriceXquantity"].ToString());
}
ssd.Totals = ssd.PriceXQ * ssd.CountOf;
SB.Items.Add(ssd);
}
else
{
ModelSender = new ErrorReporterModel
{
ErrorID = "EX567763",
Errormessage = $"محصول یافت نشد!",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
var userCookieIDV = new HttpCookie(ProjectProperies.AuthCustomerShoppingBasket());
userCookieIDV.Value = JsonConvert.SerializeObject(SB);
userCookieIDV.Expires = DateTime.Now.AddDays(2);
Response.SetCookie(userCookieIDV);
ModelSender = new ErrorReporterModel
{
ErrorID = "SX106",
Errormessage = $"با موفقیت افزوده شد!",
Errortype = "Success"
};
return(Json(ModelSender));
}
}
