public ActionResult Action(int proid, string titleimg = "0")
{
Orm.Orm_conf_all_proitems_imgs orm_Conf_All_Proitems_Imgs = new Orm.Orm_conf_all_proitems_imgs();
orm_Conf_All_Proitems_Imgs.proid = proid;
if (titleimg == "1")
{
orm_Conf_All_Proitems_Imgs.titleimg = "1";
}
else
{
orm_Conf_All_Proitems_Imgs.titleimg = "0";
}
string query = "select * from conf_all_proitems_imgs where proid=@proid and titleimg=@titleimg";
List <Orm.Orm_conf_all_proitems_imgs> orm_Conf_All_Proitems_Imgs_Lst = dbConnection.Query <Orm.Orm_conf_all_proitems_imgs>(query, orm_Conf_All_Proitems_Imgs).ToList();
if (orm_Conf_All_Proitems_Imgs_Lst.Count > 0)
{
return(Json(orm_Conf_All_Proitems_Imgs_Lst));
}
else
{
Conf_ResponseMessage conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "411";
conf_ResponseMessageObj.status = "Error";
conf_ResponseMessageObj.message = "No Data";
HttpContext.Response.StatusCode = 411;
return(Json(conf_ResponseMessageObj));
}
}
public ActionResult Action(string orderid)
{
Global.GlobalTestingLog globalTestingLog = new Global.GlobalTestingLog("AllOrderDetail");
try
{
string query = "select * from conf_all_orders where orderid='" + orderid + "'";
Orm.Orm_conf_all_orders orm_Conf_All_Orders = dbConnection.Query <Orm.Orm_conf_all_orders>(query).FirstOrDefault();
JC_OrderOutput newItem = new JC_OrderOutput();
newItem.orderid = orm_Conf_All_Orders.orderid;
newItem.disorderid = orm_Conf_All_Orders.cdt + "_" + orm_Conf_All_Orders.id;
newItem.totalprice = orm_Conf_All_Orders.totalprice;
newItem.shiped = orm_Conf_All_Orders.shipped;
newItem.payed = orm_Conf_All_Orders.payed;
newItem.cdt = orm_Conf_All_Orders.cdt;
newItem.items = new List <JC_OrderOutput_ProItem>();
newItem.status = orm_Conf_All_Orders.status;
Orm.Orm_conf_all_address orm_Conf_All_Address = new Orm.Orm_conf_all_address();
query = "select * from conf_all_address where id=" + orm_Conf_All_Orders.addressid;
orm_Conf_All_Address = dbConnection.Query <Orm.Orm_conf_all_address>(query).FirstOrDefault();
if (orm_Conf_All_Address != null)
{
newItem.name = orm_Conf_All_Address.name;
newItem.address = orm_Conf_All_Address.address;
newItem.phone = orm_Conf_All_Address.phone;
}
query = "select * from conf_all_orders_proitems where orderid='" + newItem.orderid + "'";
List <Orm.Orm_conf_all_orders_proitems> orm_Conf_All_Orders_Proitem_lst = dbConnection.Query <Orm.Orm_conf_all_orders_proitems>(query).ToList();
foreach (Orm.Orm_conf_all_orders_proitems orm_Conf_All_Orders_Proitems_Tmp in orm_Conf_All_Orders_Proitem_lst)
{
JC_OrderOutput_ProItem newProItem = new JC_OrderOutput_ProItem();
newProItem.proid = orm_Conf_All_Orders_Proitems_Tmp.proid;
query = "select * from conf_all_proitems where id=" + orm_Conf_All_Orders_Proitems_Tmp.proid;
Orm.Orm_conf_all_proitems orm_Conf_All_Proitems = dbConnection.Query <Orm.Orm_conf_all_proitems>(query).FirstOrDefault();
newProItem.title = orm_Conf_All_Proitems.title;
query = "select * from conf_all_proitems_imgs where proid=" + orm_Conf_All_Orders_Proitems_Tmp.proid + " and titleimg='1'";
Orm.Orm_conf_all_proitems_imgs orm_conf_all_proitems_imgs = dbConnection.Query <Orm.Orm_conf_all_proitems_imgs>(query).FirstOrDefault();
newProItem.img = orm_conf_all_proitems_imgs.imgpath;
query = "select * from conf_all_proitems_price where proid=" + orm_Conf_All_Orders_Proitems_Tmp.proid + " and modell1='" + orm_Conf_All_Orders_Proitems_Tmp.modell1 + "' and modell2='" + orm_Conf_All_Orders_Proitems_Tmp.modell2 + "'";
Orm.Orm_conf_all_proitems_price orm_Conf_All_Proitems_Price = dbConnection.Query <Orm.Orm_conf_all_proitems_price>(query).FirstOrDefault();
newProItem.price = orm_Conf_All_Proitems_Price.discount > 0 ? orm_Conf_All_Proitems_Price.basic * (orm_Conf_All_Proitems_Price.discount / 100.0) : orm_Conf_All_Proitems_Price.basic;
newProItem.count = orm_Conf_All_Orders_Proitems_Tmp.count;
newProItem.modell1 = orm_Conf_All_Orders_Proitems_Tmp.modell1;
newProItem.modell2 = orm_Conf_All_Orders_Proitems_Tmp.modell2;
newItem.items.Add(newProItem);
}
return(Json(newItem));
}
catch (Exception err)
{
globalTestingLog.AddRecord("stace", err.StackTrace);
globalTestingLog.AddRecord("msg", err.Message);
Conf_ResponseMessage conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "500";
conf_ResponseMessageObj.status = "error";
conf_ResponseMessageObj.message = "Faild to execute";
HttpContext.Response.StatusCode = 500;
return(Json(conf_ResponseMessageObj));
}
}
public ActionResult Action(int topicid)
{
Global.GlobalTestingLog globalTestingLog = new Global.GlobalTestingLog("MainSelectedProducts");
try
{
List <JC_TopicProducts> result = new List <JC_TopicProducts>();
string query = "select * from conf_all_proitems where id in ( select proid from conf_main_topics_products where topicsid = " + topicid + ") ";
List <Orm.Orm_conf_all_proitems> lst_Orm_conf_all_proitems = dbConnection.Query <Orm.Orm_conf_all_proitems>(query).ToList();
foreach (Orm.Orm_conf_all_proitems orm_Conf_All_Proitems_tmp in lst_Orm_conf_all_proitems)
{
//Code
JC_TopicProducts newitem = new JC_TopicProducts();
newitem.proid = orm_Conf_All_Proitems_tmp.id;
newitem.title = orm_Conf_All_Proitems_tmp.title;
newitem.des = orm_Conf_All_Proitems_tmp.des;
query = "select * from conf_all_proitems_price where proid=" + orm_Conf_All_Proitems_tmp.id;
List <Orm.Orm_conf_all_proitems_price> orm_Conf_All_Proitems_Price = dbConnection.Query <Orm.Orm_conf_all_proitems_price>(query).ToList();
if (orm_Conf_All_Proitems_Price != null && orm_Conf_All_Proitems_Price.Count > 0)
{
newitem.basicprice = orm_Conf_All_Proitems_Price[0].basic;
newitem.price = orm_Conf_All_Proitems_Price[0].discount > 0 ? orm_Conf_All_Proitems_Price[0].basic * (orm_Conf_All_Proitems_Price[0].discount / 100.0) : orm_Conf_All_Proitems_Price[0].basic;
}
else
{
newitem.basicprice = 0;
newitem.price = 0;
}
query = "select * from conf_all_proitems_imgs where proid=" + newitem.proid;
Orm.Orm_conf_all_proitems_imgs orm_Conf_All_Proitems_Imgs = dbConnection.Query <Orm.Orm_conf_all_proitems_imgs>(query).First();
if (orm_Conf_All_Proitems_Imgs != null)
{
newitem.img = orm_Conf_All_Proitems_Imgs.imgpath;
}
newitem.type_topics = topicid.ToString();
globalTestingLog.AddRecord("Step", "2");
globalTestingLog.AddRecord("proid", newitem.proid.ToString());
result.Add(newitem);
}
return(Json(result));
}
catch (Exception err)
{
globalTestingLog.AddRecord("stack:", err.StackTrace);
globalTestingLog.AddRecord("msg:", err.Message);
Conf_ResponseMessage conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "500";
conf_ResponseMessageObj.status = "Error";
conf_ResponseMessageObj.message = err.Message;
HttpContext.Response.StatusCode = 500;
return(Json(conf_ResponseMessageObj));
}
}
public ActionResult Action(string guid)
{
Global.GlobalTestingLog globalTestingLog = new Global.GlobalTestingLog("GetShopingCart");
try
{
Orm.Orm_conf_all_shopcart orm_Conf_All_Shopcart = new Orm.Orm_conf_all_shopcart();
orm_Conf_All_Shopcart.guid = guid;
string query = "select * from conf_all_shopcart where guid=@guid";
List <Orm.Orm_conf_all_shopcart> lst_orm_Conf_All_Shopcarts = dbConnection.Query <Orm.Orm_conf_all_shopcart>(query, orm_Conf_All_Shopcart).ToList();
List <JC_ShopCartItem> lst_result = new List <JC_ShopCartItem>();
foreach (Orm.Orm_conf_all_shopcart orm_Conf_All_Shopcart_tmp_obj in lst_orm_Conf_All_Shopcarts)
{
JC_ShopCartItem tmpItemObj = new JC_ShopCartItem();
tmpItemObj.shopingcartid = orm_Conf_All_Shopcart_tmp_obj.id;
tmpItemObj.proid = orm_Conf_All_Shopcart_tmp_obj.proid;
tmpItemObj.count = orm_Conf_All_Shopcart_tmp_obj.count;
tmpItemObj.selected = orm_Conf_All_Shopcart_tmp_obj.selected;
tmpItemObj.modell1 = orm_Conf_All_Shopcart_tmp_obj.modell1;
tmpItemObj.modell2 = orm_Conf_All_Shopcart_tmp_obj.modell2;
Orm.Orm_conf_all_proitems orm_Conf_All_Proitems = new Orm.Orm_conf_all_proitems();
orm_Conf_All_Proitems.id = tmpItemObj.proid;
string tmpQuery = "select * from conf_all_proitems where id = @id";
Orm.Orm_conf_all_proitems orm_Conf_All_Proitems_Selected = dbConnection.Query <Orm.Orm_conf_all_proitems>(tmpQuery, orm_Conf_All_Proitems).First();
tmpItemObj.title = orm_Conf_All_Proitems_Selected.title;
Orm.Orm_conf_all_proitems_imgs orm_Conf_All_Proitems_Imgs = new Orm.Orm_conf_all_proitems_imgs();
orm_Conf_All_Proitems_Imgs.proid = orm_Conf_All_Shopcart_tmp_obj.proid;
tmpQuery = "select * from conf_all_proitems_imgs where proid=@proid and titleimg='1'";
Orm.Orm_conf_all_proitems_imgs orm_Conf_All_Proitems_Imgs_Selected = dbConnection.Query <Orm.Orm_conf_all_proitems_imgs>(tmpQuery, orm_Conf_All_Proitems_Imgs).First();
tmpItemObj.img = orm_Conf_All_Proitems_Imgs_Selected.imgpath;
Orm.Orm_conf_all_proitems_price orm_Conf_All_Proitems_Price = new Orm.Orm_conf_all_proitems_price();
orm_Conf_All_Proitems_Price.proid = orm_Conf_All_Shopcart_tmp_obj.proid;
tmpQuery = "select * from conf_all_proitems_price where proid=@proid and modell1='" + orm_Conf_All_Shopcart_tmp_obj.modell1 + "' and modell2='" + orm_Conf_All_Shopcart_tmp_obj.modell2 + "'";
List <Orm.Orm_conf_all_proitems_price> orm_Conf_All_Proitems_Price_Selected = dbConnection.Query <Orm.Orm_conf_all_proitems_price>(tmpQuery, orm_Conf_All_Proitems_Price).ToList();
tmpItemObj.basicprice = orm_Conf_All_Proitems_Price_Selected[0].basic;
tmpItemObj.discount = orm_Conf_All_Proitems_Price_Selected[0].discount;
tmpItemObj.price = tmpItemObj.discount > 0 ? tmpItemObj.basicprice * (tmpItemObj.discount / 100.0) : tmpItemObj.basicprice;
lst_result.Add(tmpItemObj);
}
return(Json(lst_result));
}
catch (Exception err)
{
globalTestingLog.AddRecord("Stace:", err.StackTrace);
globalTestingLog.AddRecord("Msg:", err.Message);
return(Content(" "));
}
}
