public void AddOrder(Models.DonDatHang a)
{
Database db = new Database();
DataTable dtcn = db.Query("select MaChiNhanh from ChiNhanh where TenchiNhanh = N'" + a.ChiNhanh + "';");
DataTable dtkh = db.Query("select MaKH from KhachHang where HoTen = N'" + a.Khachhang + "';");
DataTable dtkm = db.Query("select MaSuKien from KhuyenMai where TenSuKien = N'" + a.KhuyenMai + "';");
DataTable dtma = db.Query("select MaKhauPhanAn from MonAn where TenKhauPhanAn = N'" + a.MonAn + "';");
db.Insert("insert into DonDatHang values (" + dtcn.Rows[0]["MaChiNhanh"].ToString() + "," + dtkh.Rows[0]["MaKH"].ToString() + ", " + dtkm.Rows[0]["MaSuKien"].ToString() + "," + a.SoLuong + ", N'" + a.TinhTrangDonHang + "' , " + dtma.Rows[0]["MaKhauPhanAn"].ToString() + " , " + a.ThanhTien + " );");
}
public JsonResult GetListOrder()
{
List <Models.DonDatHang> ListOrder = new List <Models.DonDatHang>();
Database db = new Database();
DataTable dt = db.Query("select MaDonHang from DonDatHang; ");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.DonDatHang Order = new Models.DonDatHang();
Order.MaDonDatHang = dt.Rows[i]["MaDonHang"].ToString();
ListOrder.Add(Order);
}
return(Json(ListOrder));
}
public void saveOrder(BaseController context,
string emailReceiver, string nameReceiver, string phoneReceiver, string addressReceiver,
string note, string curency)
{
//Get member account by session email
string emailSender = AccountHelper.getInstance().getLoggingInMemberEmail(context.HttpContext);
Models.KhachHang member = AccountHelper.getInstance().getMemberAccountByEmail(context.db, emailSender);
//Get shoppingCard in Sesion
List <Models.ChiTietDonDatHang> listShoppingCard = getShoppingCardInSession(context);
long totalPrice = 0;
foreach (Models.ChiTietDonDatHang record in listShoppingCard.ToList())
{
totalPrice += record.SoLuong.Value;
}
//Save order
Models.DonDatHang order = new Models.DonDatHang();
order.IdKH = member.IdKH;
order.NgayDat = DateTime.Now;
order.NguoiNhan = emailReceiver;
order.SdtNguoiNhan = phoneReceiver;
order.DiaChiNguoiNhan = addressReceiver;
order.TongTien = totalPrice;
order.DaHuy = false;
order.DaThanhToan = false;
order.TinhTrangGiaoHang = false;
context.db.DonDatHangs.Add(order);
context.db.SaveChanges(); //Submit change here to get the id of inserted record.
//Save order_details
foreach (Models.ChiTietDonDatHang record in listShoppingCard.ToList())
{
record.IdDDH = order.IdDDH;
context.db.ChiTietDonDatHangs.Add(record);
}
context.db.SaveChanges();
}
public JsonResult OrderList()
{
List <Models.DonDatHang> OrderList = new List <Models.DonDatHang>();
Database db = new Database();
DataTable dt = db.Query("select ThanhTien, MaDonHang, TenchiNhanh, HoTen, TenSuKien, ddh.SoLuong as SoLuong, TinhTrangDonHang, TenKhauPhanAn from DonDatHang as ddh, MonAn as ma, KhachHang as kh, ChiNhanh as cn, KhuyenMai as km where ddh.MaChiNhanh = cn.MaChiNhanh and ddh.MaKH = kh.MaKH and ddh.MaSuKien = km.MaSuKien and ddh.MaKhauPhanAn = ma.MaKhauPhanAn;");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.DonDatHang Order = new Models.DonDatHang();
Order.MaDonDatHang = dt.Rows[i]["MaDonHang"].ToString();
Order.ChiNhanh = dt.Rows[i]["TenchiNhanh"].ToString();
Order.Khachhang = dt.Rows[i]["HoTen"].ToString();
Order.KhuyenMai = dt.Rows[i]["TenSuKien"].ToString();
Order.SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString());
Order.TinhTrangDonHang = dt.Rows[i]["TinhTrangDonHang"].ToString();
Order.MonAn = dt.Rows[i]["TenKhauPhanAn"].ToString();
Order.ThanhTien = dt.Rows[i]["ThanhTien"].ToString();
OrderList.Add(Order);
}
return(Json(OrderList));
}
