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)); } }