public ActionResult Index(order order)
{
try
{
string phone = order.phone;
tbl_Users user = dbe.tbl_Users.Where(item => item.phone == phone).FirstOrDefault();
if (user == null)
{
tbl_Users newUser = new tbl_Users();
newUser.firstName = order.firstName;
newUser.lastName = order.lastName;
newUser.phone = order.phone;
newUser.userEmail = order.userEmail;
dbe.tbl_Users.Add(newUser);
dbe.SaveChanges();
user = dbe.tbl_Users.Where(item => item.phone == phone).FirstOrDefault();
}
tbl_orders newOrder = new tbl_orders();
newOrder.countPZ = Convert.ToInt32(order.countPZ);
newOrder.deliveredDate = Convert.ToDateTime(order.deliveredDate);
newOrder.userId = user.userId;
dbe.tbl_orders.Add(newOrder);
dbe.SaveChanges();
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
ViewBag.Message = "Thank You For Your Order!";
return(View());
}
public ActionResult Add(FormCollection form)
{
var orderToAdd = new tbl_orders();
// Deserialize (Include white list!)
TryUpdateModel(orderToAdd, new string[] { "Date", "Count" }, form.ToValueProvider());
// Validate
if (String.IsNullOrEmpty(orderToAdd.deliveredDate.ToString()))
{
ModelState.AddModelError("Delivery Date", "DeliveryDate is required!");
}
if (String.IsNullOrEmpty(orderToAdd.countPZ.ToString()))
{
ModelState.AddModelError("Count", "Count of Pizzas is required!");
}
// If valid, save movie to database
if (ModelState.IsValid)
{
//_db.AddToOrderSet(orderToAdd);
dbe.SaveChanges();
return(RedirectToAction("Index"));
}
// Otherwise, reshow form
return(View(orderToAdd));
}
public IHttpActionResult Posttbl_orders(tbl_orders tbl_orders)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tbl_orders.Add(tbl_orders);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (tbl_ordersExists(tbl_orders.ORDER_NO))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = tbl_orders.ORDER_NO }, tbl_orders));
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = AXRequest.GetQueryInt("page", 1);
txtNote_no.Text = this.note_no;
txtstart_time.Value = this.start_time;
txtstop_time.Value = this.stop_time;
this.type.SelectedValue = this.cha_type.ToString();
tbl_orders bll = new tbl_orders();
//this.Literal_pa.Text = MyConvert(bll.GetTitleSum(_strWhere + " and status<>4", "sum(payable_amount)"));
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("order_list.aspx", "type={0}&status={1}¬e_no={2}&page={3}&start_time={4}&stop_time={5}", this.cha_type.ToString(), this.status.ToString(), txtNote_no.Text, "__id__", this.start_time.ToString(), this.stop_time.ToString());
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
public IHttpActionResult Puttbl_orders(string id, tbl_orders tbl_orders)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_orders.ORDER_NO)
{
return(BadRequest());
}
db.Entry(tbl_orders).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_ordersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/**
* 生成直接支付url，支付url有效期为2小时,模式二
* @param productId 商品ID
* @return 模式二URL
*/
public string GetPayUrl(string productId)
{
tbl_canshu canshu = new tbl_canshu();
canshu.GetModel(1);
Log.Info(this.GetType().ToString(), "Native pay mode 2 url is producing...");
tbl_orders orders = new tbl_orders();
orders.GetModel(productId);
double zong = double.Parse(orders.payable_amount.ToString()) * 100;
WxPayData data = new WxPayData();
data.SetValue("body", "1111"); //商品描述
data.SetValue("attach", ""); //附加数据
data.SetValue("out_trade_no", productId); //随机字符串
data.SetValue("total_fee", zong.ToString()); //总金额
data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss")); //交易起始时间
data.SetValue("time_expire", DateTime.Now.AddMinutes(10).ToString("yyyyMMddHHmmss")); //交易结束时间
data.SetValue("goods_tag", ""); //商品标记
data.SetValue("trade_type", "NATIVE"); //交易类型
data.SetValue("product_id", productId); //商品ID
WxPayData result = WxPayApi.UnifiedOrder(data); //调用统一下单接口
string url = result.GetValue("code_url").ToString(); //获得统一下单接口返回的二维码链接
Log.Info(this.GetType().ToString(), "Get native pay mode 2 url : " + url);
return(url);
}
public override void ProcessNotify()
{
WxPayData notifyData = GetNotifyData();
//检查支付结果中transaction_id是否存在
if (!notifyData.IsSet("transaction_id"))
{
//若transaction_id不存在，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "支付结果中微信订单号不存在");
Log.Error(this.GetType().ToString(), "The Pay result is error : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
string transaction_id = notifyData.GetValue("transaction_id").ToString();
string out_trade_no = notifyData.GetValue("out_trade_no").ToString();
//查询订单，判断订单真实性
if (!QueryOrder(transaction_id))
{
//若订单查询失败，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "订单查询失败");
Log.Error(this.GetType().ToString(), "Order query failure : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
//查询订单成功
else
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
tbl_canshu canshu = new tbl_canshu();
canshu.GetModel(1);
canshu.canshu_gonggao = out_trade_no;
canshu.sys_name = transaction_id;
canshu.Update();
tbl_orders orders = new tbl_orders();
orders.GetModel(out_trade_no);
tbl_huiyuan huiyuan = new tbl_huiyuan();
huiyuan.GetModel_hui_bianhao(orders.user_bianhao);
huiyuan.huiyuan_jiebie = 1;
huiyuan.Update();
int id = orders.id;
if (orders.payment_status != 2)
{
orders.payment_status = 2;
orders.Update();
DbHelperSQL.ExecuteSql("exec sp_zhixing '" + orders.user_id + "'," + orders.order_amount + "");
DbHelperSQL.ExecuteSql("exec sp_jiangjin_4 '" + orders.user_id + "'");
}
}
}
public IHttpActionResult Gettbl_orders(string id)
{
tbl_orders tbl_orders = db.tbl_orders.Find(id);
if (tbl_orders == null)
{
return(NotFound());
}
return(Ok(tbl_orders));
}
public IHttpActionResult Deletetbl_orders(string id)
{
tbl_orders tbl_orders = db.tbl_orders.Find(id);
if (tbl_orders == null)
{
return(NotFound());
}
db.tbl_orders.Remove(tbl_orders);
db.SaveChanges();
return(Ok(tbl_orders));
}
// 单个删除
protected void delete_Click1(object sender, EventArgs e)
{
// 当前点击的按钮
this.page = AXRequest.GetQueryInt("page");
LinkButton lb = (LinkButton)sender;
string huiyuan_id = lb.CommandArgument.ToString();
tbl_huiyuan bll = new tbl_huiyuan();
if (!bll.show_is_jd(huiyuan_id) || !bll.show_is_tj(huiyuan_id))
{
mym.JscriptMsg(this.Page, "不能删除！下面已有消费者注册", "", "Error");
return;
}
bll.GetModel_hui_id(huiyuan_id);
bll.huiyuan_id = huiyuan_id;
bll.Delete(huiyuan_id);//触发器删除
tbl_shangshu ssbll = new tbl_shangshu();
ssbll.huiyuan_id = huiyuan_id;
ssbll.Delete(huiyuan_id);
tbl_shangshu2 ss2bll = new tbl_shangshu2();
ss2bll.huiyuan_id = huiyuan_id;
ss2bll.Delete(huiyuan_id);
tbl_xiaofei xfbll = new tbl_xiaofei();
xfbll.xiaofei_hui_id = huiyuan_id;
xfbll.Delete_xiaofei_hui_id(huiyuan_id);
tbl_orders orders = new tbl_orders();
orders.user_id = huiyuan_id;
orders.Delete_orders(huiyuan_id);
mym.JscriptMsg(this.Page, " 删除成功！", Utils.CombUrlTxt("al_read1.aspx", "start_time={0}&stop_time={1}&huiyuan_jiebie={2}¬e_no={3}&type={4}&page={5}", this.txtstart_time.Value, this.txtstop_time.Value, this.ddlproduct_category_id.SelectedValue, txtNote_no.Text, this.type.SelectedValue, this.page.ToString()), "Success");
}
public ActionResult doneorder(tbl_orders tb, string total)
{
tbl_orders obj = new tbl_orders();
obj.opname = tb.opname;
obj.opphone = tb.opphone;
obj.opaddress = tb.opaddress;
obj.opsaddress = tb.opsaddress;
obj.ostatus = 0;
// obj.oamount = int.Parse(total);
obj.oamount = total;
db.tbl_orders.Add(obj);
db.SaveChanges();
var moid = db.tbl_orders.Select(a => a.oid).DefaultIfEmpty(0).Max();
var pro = from prod in ok.c
join od in db.tbl_product
on prod.iid equals od.pid
select new { PID = od.pid, PPRICE = od.pprice, PQTY = prod.iqty };
foreach (var item in pro)
{
tbl_order_details orderdetails = new tbl_order_details();
orderdetails.oid = moid;
orderdetails.pid = item.PID;
orderdetails.pprice = item.PPRICE;
orderdetails.pqty = item.PQTY;
orderdetails.pamount = item.PQTY * item.PPRICE;
db.tbl_order_details.Add(orderdetails);
db.SaveChanges();
}
ok.amt = 0;
ok.c.Clear();
return(RedirectToAction("Index"));
}
public ActionResult EditOrder(int id)
{
tbl_orders order = dbmodel.ChangeOrder(id);
return(View(order));
}
public ActionResult OrderDetail(int id)
{
tbl_orders orderdetails = dbmodel.OrderDetails(id);
return(View(orderdetails));
}
public ActionResult PostOrder(string PaymentAddress, string ShipmentAddress, string PaymentMode)
{
try
{
string getLogInUser = User.Identity.Name;
string memberId = db.tbl_members.FirstOrDefault(x => x.Phone1 == getLogInUser).MemberID;
var addToCartList = db.tbl_add_to_cart.Where(x => x.MemberID == memberId).ToList();
if (addToCartList.Count == 0)
{
return(Json(new { Success = false, Message = "Please add items in to cart" }, JsonRequestBehavior.AllowGet));
}
tbl_orders order = new tbl_orders();
var settingMaster = db.tbl_kdm_settings_master.FirstOrDefault();
order.OrderID = (Int64)settingMaster.NextOrderID;
settingMaster.NextOrderID = order.OrderID + 1;
db.Entry(settingMaster).State = EntityState.Modified;
order.MemberID = addToCartList.FirstOrDefault().MemberID;
order.TotalAmount = 0;
order.TotalPV = 0;
order.TotalBV = 0;
order.PaymentAddress = PaymentAddress;
order.ShipmentAddress = ShipmentAddress;
order.OrderStatus = "Pending";
order.OrderDateTime = DateTime.Now;
order.OrderBy = User.Identity.Name;
order.OrderApprovedBy = "";
order.OrderCanceledBy = "";
order.PaymentType = PaymentMode;
addToCartList.ForEach(x =>
{
order.TotalAmount += x.MRP;
order.TotalBV += x.RB;
order.TotalPV += x.BP;
tbl_order_Line_item line = new tbl_order_Line_item();
line.OrderID = order.OrderID;
line.ProductID = x.ProductID;
line.ProductName = x.ProductName;
line.Category = x.Category;
line.Type = x.Type;
line.Code = x.Code;
line.MRP = x.MRP;
line.WP = x.WP;
line.PP = x.PP;
line.RB = x.RB;
line.BP = x.BP;
line.DP = x.DP;
line.Quantity = x.Quantity;
line.ProductDetails = x.ProductDetails;
line.Vat = x.Vat;
db.tbl_order_Line_item.Add(line);
});
db.tbl_orders.Add(order);
db.tbl_add_to_cart.RemoveRange(addToCartList);
db.SaveChanges();
ViewBag.SuccessMessage = "Order successfully Placed";
return(Json(new { Success = true, Message = "Successfully Order Placed", OrderId = order.OrderID }, JsonRequestBehavior.AllowGet));;
}
catch
{
return(Json(new { Success = false, Message = "Can't place the order" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult OrderSave(string PaymentAddress, string ShipmentAddress, string PaymentMode)
{
string getLogInUser = User.Identity.Name;
//string memberId = db.tbl_members.FirstOrDefault(x => x.Phone1 == getLogInUser).MemberID;
var addToCartList = db.tbl_add_to_cart.Where(x => x.UserName == getLogInUser).ToList();
if (addToCartList.Count == 0)
{
return(Json(new { Success = false, Message = "No order to place" }, JsonRequestBehavior.AllowGet));
}
if (PaymentMode != "MP" && PaymentMode != "COD" && PaymentMode != "WP")
{
return(Json(new { Success = false, Message = "Select the payment type" }, JsonRequestBehavior.AllowGet));
}
tbl_orders order = new tbl_orders();
var settingMaster = db.tbl_kdm_settings_master.FirstOrDefault();
order.OrderID = (Int64)settingMaster.NextOrderID;
settingMaster.NextOrderID = order.OrderID + 1;
db.Entry(settingMaster).State = EntityState.Modified;
order.MemberID = addToCartList.FirstOrDefault().MemberID;
order.TotalAmount = 0;
order.TotalPV = 0;
order.TotalBV = 0;
order.PaymentAddress = PaymentAddress;
order.ShipmentAddress = ShipmentAddress;
order.OrderStatus = "Pending";
order.OrderDateTime = DateTime.Now;
order.OrderBy = User.Identity.Name;
order.OrderApprovedBy = "";
order.OrderCanceledBy = "";
order.PaymentType = PaymentMode;
addToCartList.ForEach(x =>
{
tbl_order_Line_item line = new tbl_order_Line_item();
line.OrderID = order.OrderID;
line.ProductID = x.ProductID;
line.ProductName = x.ProductName;
line.Category = x.Category;
line.Type = x.Type;
line.Code = x.Code;
line.MRP = x.MRP;
line.WP = x.WP;
line.PP = x.PP;
line.DP = x.DP;
line.SP = x.SP;
line.RB = x.RB;
line.BP = x.BP;
line.Quantity = x.Quantity;
line.ProductDetails = x.ProductDetails;
line.Vat = x.Vat;
db.tbl_order_Line_item.Add(line);
order.TotalAmount += (x.DP);
order.TotalBV += x.RB;
order.TotalPV += x.BP;
});
db.tbl_orders.Add(order);
db.tbl_add_to_cart.RemoveRange(addToCartList);
db.SaveChanges();
ViewBag.SuccessMessage = "Order successfully Placed";
return(Json(order, JsonRequestBehavior.AllowGet));
//ViewBag.PageTitle = "Order MANAGEMENT 2";
//Dictionary<string, string> PanelTitles = new Dictionary<string, string>();
//PanelTitles["OrderDetails"] = "Order Details";
//ViewBag.PanelTitles = PanelTitles;
//tbl_orders order = new tbl_orders();
//order.ProductID = db.tbl_products_master.FirstOrDefault(x => x.Code == orderViewModel.ProductCode).ProductID;
//order.Quantity = (decimal)orderViewModel.Quantity;
//order.ProductName = "";
//order.ProductTypeID = orderViewModel.ProductTypeID;
//order.ProductTypeName = "";
//order.MRP = (decimal)orderViewModel.MRP;
//order.MemberID = orderViewModel.MemberID;
//order.BP = orderViewModel.BP;
//order.RB = orderViewModel.RB;
//order.TotalAmount = (decimal)orderViewModel.TotalAmount;
//order.TotalPV = orderViewModel.TotalPV;
//order.TotalBV = orderViewModel.TotalBV;
//order.DealerID = orderViewModel.DealerID;
//order.PaymentAddress = orderViewModel.PaymentAddress;
//order.ShipmentAddress = orderViewModel.ShipmentAddress;
//order.OrderStatus = "Pending";
//order.OrderDateTime = DateTime.Now;
//order.OrderBy = orderViewModel.OrderBy;
//order.OrderApprovedBy = "";
//order.OrderCanceledBy = "";
//db.tbl_orders.Add(order);
//db.SaveChanges();
//order.OrderID = db.tbl_orders.ToList().LastOrDefault().OrderID;
//ViewBag.SuccessMessage = "Order successfully Placed";
//return Json(order, JsonRequestBehavior.AllowGet);
}
