public void AddDelivery(Models.GiaoHang a)
{
Database db = new Database();
DataTable dtnv = db.Query("select MaNV from NhanVien where TenNV = N'" + a.NguoiGiaoHang + "';");
db.Insert("insert into GiaoHang values (" + a.MaDonHang + "," + dtnv.Rows[0]["MaNV"].ToString() + ", '" + a.ThoiGianGiaoHang + "');");
}
public JsonResult DeliveryList()
{
List <Models.GiaoHang> DeliveryList = new List <Models.GiaoHang>();
Database db = new Database();
DataTable dt = db.Query("select MAGH, ddh.MaDonHang as MaDonHang, TenNV, ThoiGian from GiaoHang as gh, NhanVien as nv, DonDatHang as ddh where gh.MaDonHang = ddh.MaDonHang and gh.NguoiGiaoHang = nv.MaNV;");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.GiaoHang Delivery = new Models.GiaoHang();
Delivery.MaDonHang = dt.Rows[i]["MaDonHang"].ToString();
Delivery.NguoiGiaoHang = dt.Rows[i]["TenNV"].ToString();
Delivery.ThoiGianGiaoHang = dt.Rows[i]["ThoiGian"].ToString();
Delivery.MaGiaoHang = dt.Rows[i]["MAGH"].ToString();
DeliveryList.Add(Delivery);
}
return(Json(DeliveryList));
}
