public ActionResult Action(string data)
{
Global.GlobalTestingLog globalTestingLog = new Global.GlobalTestingLog("SetConfAllOrdersNew");
try
{
if (string.IsNullOrEmpty(data))
{
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));
}
else
{
JC_ConfAllOrders jC_ConfAllOrders = (JC_ConfAllOrders)JsonConvert.DeserializeObject(data, typeof(JC_ConfAllOrders));
string query = "";
double totalprice = 0.0;
string orderid = Guid.NewGuid().ToString();
foreach (JC_ConfAllOrders_Item shopingcartitem in jC_ConfAllOrders.items)
{
totalprice = totalprice + shopingcartitem.price;
if (shopingcartitem.shopcartid != null && shopingcartitem.shopcartid > 0)
{
query = "delete from conf_all_shopcart where id=" + shopingcartitem.shopcartid;
dbConnection.Execute(query);
}
query = "insert into conf_all_orders_proitems(proid,orderid,count,modell1,modell2) values(" + shopingcartitem.proid + ",'" + orderid + "'," + shopingcartitem.count + ",'" + shopingcartitem.modell1 + "','" + shopingcartitem.modell2 + "')";
dbConnection.Execute(query);
}
string cdt = DateTime.Now.ToString("yyyyMMdd");
query = "insert into conf_all_orders(orderid,payed,cdt,returned,addressid,guid,totalprice,shiped,status) values('" + orderid + "','0','" + cdt + "','0','" + jC_ConfAllOrders.addressid + "','" + jC_ConfAllOrders.guid + "'," + totalprice + ",'0','1')";
dbConnection.Execute(query);
Orm.Orm_conf_all_address orm_Conf_All_Address = new Orm.Orm_conf_all_address();
query = "select * from conf_all_address where id=" + jC_ConfAllOrders.addressid;
orm_Conf_All_Address = dbConnection.Query <Orm.Orm_conf_all_address>(query).FirstOrDefault();
if (orm_Conf_All_Address != null)
{
Orm.Orm_conf_all_orders_address orm_conf_all_orders_address = new Orm.Orm_conf_all_orders_address();
orm_conf_all_orders_address.guid = orm_Conf_All_Address.guid;
orm_conf_all_orders_address.name = orm_Conf_All_Address.name;
orm_conf_all_orders_address.country = orm_Conf_All_Address.country;
orm_conf_all_orders_address.city = orm_Conf_All_Address.city;
orm_conf_all_orders_address.state = orm_Conf_All_Address.state;
orm_conf_all_orders_address.district = orm_Conf_All_Address.district;
orm_conf_all_orders_address.address = orm_Conf_All_Address.address;
orm_conf_all_orders_address.phone = orm_Conf_All_Address.phone;
orm_conf_all_orders_address.orderid = orderid;
query = "insert into conf_all_orders_address(orderid,guid,name,country,state,city,district,address,phone) values(@orderid,@guid,@name,@country,@state,@city,@district,@address,@phone)";
dbConnection.Execute(query, orm_conf_all_orders_address);
}
Conf_ResponseMessage conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "200";
conf_ResponseMessageObj.status = "OK";
conf_ResponseMessageObj.message = orderid;
HttpContext.Response.StatusCode = 200;
return(Json(conf_ResponseMessageObj));
}
}
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 = "User existed.";
HttpContext.Response.StatusCode = 500;
return(Json(conf_ResponseMessageObj));
}
}
public ActionResult Action(string guid)
{
Global.GlobalTestingLog globalTestingLog = new Global.GlobalTestingLog("GetConfAllOrders");
try
{
string query = "select * from conf_all_orders where guid='" + guid + "'";
List <JC_OrderOutput> jC_OrderOutputs = new List <JC_OrderOutput>();
List <Orm.Orm_conf_all_orders> orm_Conf_All_Orders = dbConnection.Query <Orm.Orm_conf_all_orders>(query).ToList();
foreach (Orm.Orm_conf_all_orders orm_Conf_All_Orders_tmp in orm_Conf_All_Orders)
{
JC_OrderOutput newItem = new JC_OrderOutput();
newItem.orderid = orm_Conf_All_Orders_tmp.orderid;
newItem.cdt = orm_Conf_All_Orders_tmp.cdt;
newItem.disorderid = orm_Conf_All_Orders_tmp.cdt + "_" + orm_Conf_All_Orders_tmp.id;
newItem.totalprice = orm_Conf_All_Orders_tmp.totalprice;
newItem.shiped = orm_Conf_All_Orders_tmp.shipped;
newItem.payed = orm_Conf_All_Orders_tmp.payed;
newItem.items = new List <JC_OrderOutput_ProItem>();
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();
if (orm_Conf_All_Proitems != null)
{
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();
if (orm_conf_all_proitems_imgs != null)
{
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();
if (orm_Conf_All_Proitems_Price != null)
{
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);
}
query = "select * from conf_all_orders_address where orderid='" + newItem.orderid + "'";
Orm.Orm_conf_all_orders_address orm_Conf_All_Orders_Address = dbConnection.Query <Orm.Orm_conf_all_orders_address>(query).FirstOrDefault();
if (orm_Conf_All_Orders_Address != null)
{
newItem.address = orm_Conf_All_Orders_Address.address;
newItem.name = orm_Conf_All_Orders_Address.name;
newItem.phone = orm_Conf_All_Orders_Address.phone;
}
jC_OrderOutputs.Add(newItem);
}
return(Json(jC_OrderOutputs));
}
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));
}
}
