public List <ChiTietDonDichVu> GetDataDichVu(int MaDonDatHang)
{
try
{
List <ChiTietDonDichVu> dsChiTietDonDatDichVu = new List <ChiTietDonDichVu>();
DataTable dt = dataProvider.ExecuteQuery("proc_getdata_chitietdondat_dichvu", new object[] { MaDonDatHang }, new List <string>()
{
"MaDonDatHang"
});
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ChiTietDonDichVu chiTietDonDichVu = new ChiTietDonDichVu();
chiTietDonDichVu.MaDonDatHang = String.IsNullOrEmpty(row["MaDonDatHang"].ToString()) ? 0 : int.Parse(row["MaDonDatHang"].ToString());
chiTietDonDichVu.TenDichVu = String.IsNullOrEmpty(row["TenDV"].ToString()) ? "" : row["TenDV"].ToString();
chiTietDonDichVu.MaDV = String.IsNullOrEmpty(row["MaDV"].ToString()) ? 0 : int.Parse(row["MaDV"].ToString());
chiTietDonDichVu.Gia = String.IsNullOrEmpty(row["Gia"].ToString()) ? 0 : float.Parse(row["Gia"].ToString());
dsChiTietDonDatDichVu.Add(chiTietDonDichVu);
}
return(dsChiTietDonDatDichVu);
}
return(new List <ChiTietDonDichVu>());
}
catch (Exception ex)
{
return(new List <ChiTietDonDichVu>());
}
}
public List <ChiTietDonDichVu> GetData()
{
try
{
List <ChiTietDonDichVu> dsChiTietDonDichVu = new List <ChiTietDonDichVu>();
DataTable dt = dataProvider.ExecuteQuery("Proc_ChiTietDonDichVu_GetData", null, null);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ChiTietDonDichVu chiTietDonDichVu = new ChiTietDonDichVu();
chiTietDonDichVu.MaDonDatHang = String.IsNullOrEmpty(row["MaDonDatHang"].ToString()) ? 0 : int.Parse(row["MaDonDatHang"].ToString());
chiTietDonDichVu.MaDV = String.IsNullOrEmpty(row["MaDV"].ToString()) ? 0 : int.Parse(row["MaDV"].ToString());;
dsChiTietDonDichVu.Add(chiTietDonDichVu);
}
return(dsChiTietDonDichVu);
}
return(new List <ChiTietDonDichVu>());
}
catch (Exception ex)
{
return(new List <ChiTietDonDichVu>());
}
}
public string ThemChiTietDonDichVu(ChiTietDonDichVu chiTietDonDichVu)
{
try
{
string rs = "";
rs = dataProvider.ExecuteScalar("Proc_ChiTietDonDichVu_Insert", new object[] { chiTietDonDichVu.MaDonDatHang, chiTietDonDichVu.MaDV },
new List <string>()
{
"@MaDonDatHang",
"@MaDV"
});
return(rs);
}
catch (Exception ex)
{
return("");
}
}
public JsonResult ThemHoaDonDichVu(string HoTenNguoiNhan, string SoDienThoaiNguoiNhan, string HinhThucThanhToan, string TrangThai, List <GioHangItem> cartModel)
{
DonDatHangModel donDatHangModel = new DonDatHangModel();
DonDatHang donDatHang = new DonDatHang();
if (Session["ADMIN_SESSION"] != null)
{
NhanVien nhanVien = new NhanVienModel().GetNhanVienByEmail(Session["ADMIN_SESSION"].ToString());
donDatHang.MaNV = nhanVien.MaNV;
}
donDatHang.HoTenNguoiNhan = HoTenNguoiNhan;
donDatHang.SoDTGiaoHang = SoDienThoaiNguoiNhan;
donDatHang.HinhThucThanhToan = HinhThucThanhToan;
donDatHang.NgayTao = DateTime.Now;
donDatHang.TrangThaiDonSanPham = 0;
donDatHang.TrangThaiDonDichVu = Convert.ToInt32(TrangThai);
string MaDonHang = donDatHangModel.ThemDonDatHang(donDatHang);
ChiTietDonDichVuModel chiTietDonDichVuModel = new ChiTietDonDichVuModel();
foreach (var item in cartModel)
{
ChiTietDonDichVu chiTietDonDichVu = new ChiTietDonDichVu();
chiTietDonDichVu.MaDonDatHang = Convert.ToInt32(MaDonHang);
chiTietDonDichVu.MaDV = item.dichvu.MaDV;
chiTietDonDichVuModel.ThemChiTietDonDichVu(chiTietDonDichVu);
}
donDatHangModel.CapNhatTongTienDichVu(Convert.ToInt32(MaDonHang));
string Message = "Thanh cong";
return(Json(Message, JsonRequestBehavior.AllowGet));
}
