// GET: Admin/Order
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new OrderD();
var model = dao.ListAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public bool InsertOrderD(OrderD orderdData)
{
if (orderdData == null)
{
return(false);
}
db.OrderD.Add(orderdData);
db.SaveChanges();
return(true);
}
public bool DeleteOrderDBy(Guid Orderdtsno)
{
OrderD OldData = db.OrderD.Find(Orderdtsno);
if (OldData == null)
{
return(false);
}
db.OrderD.Remove(OldData);
db.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userid == userid);
if (userinfo == null)
{
return(SetError("用户不存在！"));
}
OrderH orderH = new OrderH()
{
Amt = itemArr.Sum(o => o.amt),
CreateTime = DateTime.Now,
UserId = userid,
Start = 0,
Source = key,
Discount = 0,
ReceiveAddress = Receiveaddress,
Realamt = itemArr.Sum(o => o.price),
Phone = Phone,
OrderhId = Guid.NewGuid().ToString().Replace("-", "")
};
hxsc.OrderH.AddObject(orderH);
foreach (var itemn in itemArr)
{
OrderD orderD = new OrderD()
{
Amt = itemn.amt,
Createtime = DateTime.Now,
Discount = itemn.discount,
Itemid = itemn.itemid,
Start = 0,
Serial = itemn.serial,
Realamt = itemn.realamt,
Price = itemn.price,
Number = itemn.number,
Orderhid = orderH.OrderhId
};
hxsc.OrderD.AddObject(orderD);
}
hxsc.SaveChanges();
return(true);
}
public ActionResult Payment(string shipName, string mobile, string address, string email)
{
var order = new Order();
order.CreateDate = DateTime.Now;
order.ShipAddress = address;
order.ShipPet = mobile;
order.ShipName = shipName;
order.ShipEmail = email;
try
{
var id = new OrderD().Insert(order);
var cart = (List <CartItem>)Session[CartSession];
decimal total = 0;
var detailDao = new OrderDetailD();
foreach (var item in cart)
{
var orderDetail = new OrderDetail();
orderDetail.ProductID = item.Product.ID;
orderDetail.OderID = id;
orderDetail.Price = (decimal)item.Product.Price;
orderDetail.Quantity = item.Quantity;
detailDao.Insert(orderDetail);
total += (item.Product.Price.GetValueOrDefault(0) * item.Quantity);
}
string content = System.IO.File.ReadAllText(Server.MapPath("~/assets/client/template/donbanhang.html"));
content = content.Replace("{{CustomerName}}", shipName);
content = content.Replace("{{Phone}}", mobile);
content = content.Replace("{{Email}}", email);
content = content.Replace("{{Address}}", address);
content = content.Replace("{{Total}}", total.ToString("N0"));
var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(email, "Đơn hàng mới từ Leo Pet Shop Online", content);
new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Leo Pet Shop Online", content);
}
catch (Exception ex)
{
//ghi lại log
return(Redirect("/loi-thanh-toan"));
}
return(Redirect("/hoan-thanh"));
}
public bool UpdateOrderDBy(OrderD orderdData)
{
OrderD OldData = db.OrderD.Find(orderdData.Orderdtsno);
if (OldData == null)
{
return(false);
}
OldData.serno = orderdData.serno;
OldData.Quantity = orderdData.Quantity;
OldData.Modifydt = DateTime.Now;
db.SaveChanges();
return(true);
}
public static OrderD orderD(T_Order_D item)
{
if (item == null)
{
return(null);
}
var data = new OrderD()
{
id = item.id,
hId = item.hId,
productId = item.productId,
qty = item.qty,
unitPrice = item.unitPrice
};
//if (item.M_Product != null) data.product = Masters.product(item.M_Product);
return(data);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
ReturnedH ReturnedH = hxsc.ReturnedH.FirstOrDefault(o => o.ReturnedId == returnedid);
if (ReturnedH == null)
{
return(SetError("退货单不存在!"));
}
if (ReturnedH.State != 0)
{
return(SetError("已经退货!"));
}
OrderH orderH = hxsc.OrderH.FirstOrDefault(o => o.OrderhId == ReturnedH.Orderid);
if (orderH == null)
{
return(SetError("订单不存在!"));
}
if (orderH.Start == 0)
{
return(SetError("未付款订单不能退货!"));
}
var returnedD = (from o in hxsc.ReturnedD
where o.Returnedid == returnedid
select o).ToList();
ReturnedH.State = state;
foreach (var item in returnedD)
{
item.State = state;
OrderD orderD = hxsc.OrderD.FirstOrDefault(o => o.Itemid == item.Itemid);
if (orderD != null)
{
orderD.Start = 3;
}
}
hxsc.SaveChanges();
return(true);
}
public bool UpdateOrderDBy(OrderD orderdData)
{
return(Repository_OrderD_P.UpdateOrderDBy(orderdData));
}
public bool InsertOrderD(OrderD orderdData)
{
return(Repository_OrderD_P.InsertOrderD(orderdData));
}
public OrderD OrderDFillBy(Guid Orderdtsno)
{
OrderD SearchData = db.OrderD.Find(Orderdtsno);
return(SearchData);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
string[] itemidArr = itemidList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (itemidArr.Length == 0)
{
return(SetError("图书信息不能为空!"));
}
foreach (var sitemid in itemidArr)
{
int itemid = 0;
int.TryParse(sitemid, out itemid);
Item item = hxsc.Item.FirstOrDefault(o => o.Itemid == itemid);
if (item == null)
{
return(SetError("图书信息不存在!"));
}
OrderD orderD = new OrderD()
{
Amt = item.Price,
Createtime = DateTime.Now,
Discount = 1,
Itemid = itemid,
Number = 1,
Orderhid = "",
Price = item.Price,
Realamt = item.Price,
Serial = 0,
Start = 0
};
list.Add(orderD);
}
OrderH orderH = new OrderH()
{
Amt = 0,
CreateTime = DateTime.Now,
Discount = 0,
Express = "",
ExpressNo = "",
ExpressTime = DateTime.Now,
Phone = "",
Realamt = 0,
ReceiveAddress = "",
Source = key,
Start = 0,
UserId = userid
};
hxsc.OrderH.AddObject(orderH);
hxsc.SaveChanges();
foreach (var item in list)
{
item.Orderhid = orderH.OrderhId;
hxsc.OrderD.AddObject(item);
}
hxsc.SaveChanges();
return(true);
}
