public string Ghi_Ban_hang_Moi(string Ma_so_San_pham, string Chuoi_Xml_Ban_hang)
{
var San_pham = XL_NGHIEP_VU.Tim_San_pham(Ma_so_San_pham, Du_lieu_Dich_vu);
var Ban_hang = XL_NGHIEP_VU.Tao_Doi_tuong_Con(Chuoi_Xml_Ban_hang, San_pham);
var Chuoi_Kq_Ghi = XL_LUU_TRU.Ghi_Ban_hang_Moi(San_pham, Ban_hang);
if (Chuoi_Kq_Ghi == "OK")
{
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_San_pham(San_pham);
San_pham.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_San_pham(San_pham, DateTime.Today);
San_pham.SetAttribute("Doanh_thu", Doanh_thu.ToString());
//Cập nhật Doanh thu Nhóm Sản phẩm
var Cua_hang = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Cua_hang")[0];
var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
var DS_Nhom_San_pham_cua_Nguoi_dung = (XmlElement)Danh_sach_Nguoi_dung.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
var Danh_sach_Nhom_San_pham_cua_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_San_pham_cua_Nguoi_dung, "Nhom_San_pham");
var Ma_so_Nhom_San_pham = San_pham.SelectSingleNode("Nhom_San_pham/@Ma_so").Value;
var Nhom_San_pham_Nguoi_dung = Danh_sach_Nhom_San_pham_cua_Nguoi_dung.FirstOrDefault(x => x.GetAttribute("Ma_so") == Ma_so_Nhom_San_pham);
var Tien = long.Parse(Ban_hang.GetAttribute("Tien"));
var Doanh_thu_Nhom_San_pham = long.Parse(Nhom_San_pham_Nguoi_dung.GetAttribute("Doanh_thu"));
Doanh_thu_Nhom_San_pham += Tien;
Nhom_San_pham_Nguoi_dung.SetAttribute("Doanh_thu", Doanh_thu_Nhom_San_pham.ToString());
}
var Chuoi_Xml_Kq = $"<DU_LIEU Kq='{Chuoi_Kq_Ghi}' />";
return(Chuoi_Xml_Kq);
}
void Khoi_dong_Du_lieu_cua_Dich_vu()
{
var Du_lieu_Luu_tru = XL_LUU_TRU.Doc_Du_lieu();
var Chuoi_XML = Du_lieu_Luu_tru.OuterXml;
var Tai_lieu = new XmlDocument();
Tai_lieu.LoadXml(Chuoi_XML);
Du_lieu_Dich_vu = Tai_lieu.DocumentElement;
var Danh_sach_Laptop = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Danh_sach_Laptop")[0];
var Cong_ty = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Cong_ty")[0];
var Danh_sach_Nhom_Laptop = (XmlElement)Cong_ty.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
// ===================== Bổ sung thông tin ===============================
foreach (XmlElement Laptop in Danh_sach_Laptop.GetElementsByTagName("Laptop"))
{
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_ton_Laptop(Laptop);
Laptop.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Laptop(Laptop);
Laptop.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
foreach (XmlElement Nhom_Laptop in Danh_sach_Nhom_Laptop.GetElementsByTagName("Nhom_Lap_top"))
{
var Danh_sach_Laptop_cua_Nhom_Laptop = XL_NGHIEP_VU.Tao_Danh_sach_Laptop_cua_Nhom_Laptop(Nhom_Laptop, Danh_sach_Laptop);
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_Laptop(Danh_sach_Laptop_cua_Nhom_Laptop);
Nhom_Laptop.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_Laptop(Danh_sach_Laptop_cua_Nhom_Laptop);
Nhom_Laptop.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
}
public XmlElement Tao_Du_lieu_cua_Ung_dung_Quan_ly_Ban_hang()
{
var Chuoi_XML = Du_lieu_Dich_vu.OuterXml;
var Tai_lieu = new XmlDocument();
Tai_lieu.LoadXml(Chuoi_XML);
var Du_lieu = Tai_lieu.DocumentElement;
var Cua_hang = (XmlElement)Du_lieu.GetElementsByTagName("Cong_ty")[0];
var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
var DS_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(Danh_sach_Nguoi_dung, "Nguoi_dung");
foreach (XmlElement Nguoi_dung in DS_Nguoi_dung)
{
if (Nguoi_dung.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value != "QUAN_LY_BAN_HANG" &&
Nguoi_dung.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value != "BAN_HANG")
{
Danh_sach_Nguoi_dung.RemoveChild(Nguoi_dung);// Xóa Các Người dùng không thuộc Nhóm tương ứng
}
}
foreach (XmlElement Lap_top in Du_lieu.GetElementsByTagName("Laptop"))
{
var Danh_sach_Ban_hang = (XmlElement)Lap_top.GetElementsByTagName("Danh_sach_Ban_hang")[0];
Lap_top.RemoveChild(Danh_sach_Ban_hang);
var Danh_sach_Nhap_hang = (XmlElement)Lap_top.GetElementsByTagName("Danh_sach_Dat_hang")[0];
Lap_top.RemoveChild(Danh_sach_Nhap_hang);
}// Xóa Tất các Nhập hàng, Bán hàng
return(Du_lieu);
}
public XmlElement Tao_Du_lieu_cua_Ung_dung_Nhan_vien_Ban_hang()
{
var Chuoi_XML = Du_lieu_Dich_vu.OuterXml;
var Tai_lieu = new XmlDocument();
Tai_lieu.LoadXml(Chuoi_XML);
var Du_lieu = Tai_lieu.DocumentElement;
var Cua_hang = (XmlElement)Du_lieu.GetElementsByTagName("Cua_hang")[0];
var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
var DS_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(Danh_sach_Nguoi_dung, "Nguoi_dung");
foreach (XmlElement Nguoi_dung in DS_Nguoi_dung)
{
if (Nguoi_dung.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value != "BAN_HANG")
{
Danh_sach_Nguoi_dung.RemoveChild(Nguoi_dung);// Xóa Các Người dùng không thuộc Nhóm tương ứng
}
}
foreach (XmlElement San_pham in Du_lieu.GetElementsByTagName("San_pham"))
{
if (San_pham.GetElementsByTagName("Danh_sach_Nhap_hang").Count > 0)
{
var Danh_sach_Ban_hang = (XmlElement)San_pham.GetElementsByTagName("Danh_sach_Ban_hang")[0];
San_pham.RemoveChild(Danh_sach_Ban_hang);
var Danh_sach_Nhap_hang = (XmlElement)San_pham.GetElementsByTagName("Danh_sach_Nhap_hang")[0];
San_pham.RemoveChild(Danh_sach_Nhap_hang);
}
}// Xóa Tất các Nhập hàng, Bán hàng
return(Du_lieu);
}
//============= Xử lý Chức năng ========
public XL_NGUOI_DUNG_DANG_NHAP Dang_nhap(string Ten_Dang_nhap, string Mat_khau)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)null;
var Danh_sach_Quan_ly_Ban_hang = Danh_sach_Nguoi_dung.FindAll(x => x.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value == "QUAN_LY_BAN_HANG");
var Danh_sach_Nhan_vien_Ban_hang = Danh_sach_Nguoi_dung.FindAll(x => x.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value == "BAN_HANG");
var Nguoi_dung = Danh_sach_Quan_ly_Ban_hang.FirstOrDefault(
x => x.GetAttribute("Ten_Dang_nhap") == Ten_Dang_nhap && x.GetAttribute("Mat_khau") == Mat_khau);
if (Nguoi_dung != null)
{
// Thống tin Online
Nguoi_dung_Dang_nhap = new XL_NGUOI_DUNG_DANG_NHAP();
Nguoi_dung_Dang_nhap.Ho_ten = Nguoi_dung.GetAttribute("Ho_ten");
Nguoi_dung_Dang_nhap.Ma_so = Nguoi_dung.GetAttribute("Ma_so");
Nguoi_dung_Dang_nhap.Cua_hang = Cua_hang;
Nguoi_dung_Dang_nhap.Danh_sach_San_pham = Danh_sach_San_pham;
Nguoi_dung_Dang_nhap.Danh_sach_Nhom_San_pham = Danh_sach_Nhom_San_pham;
Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat = Danh_sach_Phieu_dat;
Nguoi_dung_Dang_nhap.Danh_sach_Nhan_vien_Ban_hang = Danh_sach_Nhan_vien_Ban_hang;
Nguoi_dung_Dang_nhap.Danh_sach_San_pham_Xem = Nguoi_dung_Dang_nhap.Danh_sach_San_pham;
//Bổ xung thông tin cho Nhân viên Bán hàng
Danh_sach_Nhan_vien_Ban_hang.ForEach(Nhan_vien =>
{
var DS_Nhom_San_pham_Nhan_vien = (XmlElement)Nhan_vien.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
var Danh_sach_Nhom_San_pham_Nhan_vien = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_San_pham_Nhan_vien, "Nhom_San_pham");
var Doanh_thu = Danh_sach_Nhom_San_pham_Nhan_vien.Sum(x => long.Parse(x.GetAttribute("Doanh_thu")));
Nhan_vien.SetAttribute("Doanh_thu", Doanh_thu.ToString());
});
HttpContext.Current.Session["Nguoi_dung_Dang_nhap"] = Nguoi_dung_Dang_nhap;
}
return(Nguoi_dung_Dang_nhap);
}
//============= Xử lý Chức năng ========
public XL_NGUOI_DUNG_DANG_NHAP Dang_nhap(string Ten_Dang_nhap, string Mat_khau)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)null;
var Nguoi_dung = Danh_sach_Nguoi_dung.FirstOrDefault(
x => x.GetAttribute("Ten_Dang_nhap") == Ten_Dang_nhap && x.GetAttribute("Mat_khau") == Mat_khau);
if (Nguoi_dung != null)
{
var DS_Nhom_Lap_top = (XmlElement)Nguoi_dung.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
var Danh_sach_Nhom_Lap_top_cua_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_Lap_top, "Nhom_Lap_top");
var Danh_sach_Lap_top_cua_Nguoi_dung = Danh_sach_Lap_top.FindAll(
x => Danh_sach_Nhom_Lap_top_cua_Nguoi_dung.Any(Nhom => Nhom.GetAttribute("Ma_so") == x.SelectSingleNode("Nhom_Lap_top/@Ma_so").Value));
var Doanh_thu = Danh_sach_Nhom_Lap_top_cua_Nguoi_dung.Sum(Nhom_Lap_top => long.Parse(Nhom_Lap_top.GetAttribute("Doanh_thu")));
// Thống tin Online
Nguoi_dung_Dang_nhap = new XL_NGUOI_DUNG_DANG_NHAP();
Nguoi_dung_Dang_nhap.Doanh_thu = Doanh_thu;
Nguoi_dung_Dang_nhap.Thong_bao = $"Doanhthu: { Nguoi_dung_Dang_nhap.Doanh_thu}" + "$<br />";
Nguoi_dung_Dang_nhap.Danh_sach_Lap_top = Danh_sach_Lap_top_cua_Nguoi_dung;
Nguoi_dung_Dang_nhap.Danh_sach_Nhom_Lap_top = Danh_sach_Nhom_Lap_top_cua_Nguoi_dung;
Nguoi_dung_Dang_nhap.Danh_sach_Lap_top_Xem = Nguoi_dung_Dang_nhap.Danh_sach_Lap_top;
HttpContext.Current.Session["Nguoi_dung_Dang_nhap"] = Nguoi_dung_Dang_nhap;
}
return(Nguoi_dung_Dang_nhap);
}
public static string Tao_Chuoi_HTML_Danh_sach_Nhan_vien_Ban_hang
(List <XmlElement> Danh_sach_Nhan_vien, List <XmlElement> Danh_sach_San_pham, List <XmlElement> Danh_sach_Nhom_San_pham)
{
var Chuoi_HTML_Danh_sach = "<div class='row'>";
Danh_sach_Nhan_vien.ForEach(Nhan_vien =>
{
var Danh_sach_San_pham_cua_Nhan_vien = XL_NGHIEP_VU.Tao_Danh_sach_San_pham_cua_Nhan_vien_Ban_hang(Nhan_vien, Danh_sach_San_pham);
var Doanh_thu = long.Parse(Nhan_vien.GetAttribute("Doanh_thu"));
var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{Nhan_vien.GetAttribute("Ma_so")}.png' " +
"style='width:50px;height:50px;' />";
var Chuoi_Thong_tin = $"<div class='btn text-left' > " +
$"{Nhan_vien.GetAttribute("Ho_ten")}" +
$"<br /><i><b>Doanh thu: {Doanh_thu.ToString("n0", Dinh_dang_VN)}</b></i>" +
$"</div>";
var DS_Nhom_San_pham = (XmlElement)Nhan_vien.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
var Danh_sach_Nhom_San_pham_cua_Nhan_vien = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_San_pham, "Nhom_San_pham");
var Chuoi_Nhom_San_pham = Tao_Chuoi_HTML_Danh_sach_Nhom_San_pham_Xem(Danh_sach_Nhom_San_pham_cua_Nhan_vien);
var Chuoi_HTML = $"<div class='col-md-5'>" +
$"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" + $"{Chuoi_Nhom_San_pham}" +
"</div>";
Chuoi_HTML_Danh_sach += Chuoi_HTML;
});
Chuoi_HTML_Danh_sach += "</div>";
return(Chuoi_HTML_Danh_sach);
}
//============= Xử lý Chức năng ========
public XL_NGUOI_DUNG_DANG_NHAP Dang_nhap(string Ten_Dang_nhap, string Mat_khau)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)null;
var Nguoi_dung = Danh_sach_Nguoi_dung.FirstOrDefault(
x => x.GetAttribute("Ten_Dang_nhap") == Ten_Dang_nhap && x.GetAttribute("Mat_khau") == Mat_khau);
if (Nguoi_dung != null)
{
var DS_Nhom_San_pham = (XmlElement)Nguoi_dung.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
var Danh_sach_Nhom_San_pham_cua_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_San_pham, "Nhom_San_pham");
var Danh_sach_San_pham_cua_Nguoi_dung = Danh_sach_San_pham.FindAll(
x => Danh_sach_Nhom_San_pham_cua_Nguoi_dung.Any(Nhom => Nhom.GetAttribute("Ma_so") == x.SelectSingleNode("Nhom_San_pham/@Ma_so").Value));
var Doanh_thu = Danh_sach_Nhom_San_pham_cua_Nguoi_dung.Sum(x => long.Parse(x.GetAttribute("Doanh_thu")));
// Thống tin Online
Nguoi_dung_Dang_nhap = new XL_NGUOI_DUNG_DANG_NHAP();
Nguoi_dung_Dang_nhap.Ho_ten = Nguoi_dung.GetAttribute("Ho_ten");
Nguoi_dung_Dang_nhap.Ma_so = Nguoi_dung.GetAttribute("Ma_so");
Nguoi_dung_Dang_nhap.Doanh_thu = Doanh_thu;
Nguoi_dung_Dang_nhap.Cua_hang = Cua_hang;
Nguoi_dung_Dang_nhap.Danh_sach_San_pham = Danh_sach_San_pham_cua_Nguoi_dung;
Nguoi_dung_Dang_nhap.Danh_sach_Nhom_San_pham = Danh_sach_Nhom_San_pham_cua_Nguoi_dung;
Nguoi_dung_Dang_nhap.Danh_sach_San_pham_Xem = Nguoi_dung_Dang_nhap.Danh_sach_San_pham;
HttpContext.Current.Session["Nguoi_dung_Dang_nhap"] = Nguoi_dung_Dang_nhap;
}
return(Nguoi_dung_Dang_nhap);
}
//============= Xử lý Chức năng ========
public XL_NGUOI_DUNG_DANG_NHAP Dang_nhap(string Ten_Dang_nhap, string Mat_khau)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)null;
var Nguoi_dung = Danh_sach_Nguoi_dung.FirstOrDefault(
x => x.GetAttribute("Ten_Dang_nhap") == Ten_Dang_nhap && x.GetAttribute("Mat_khau") == Mat_khau &&
x.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value == "QUAN_LY_BAN_HANG");
if (Nguoi_dung != null)
{
var DS_Nhom_Lap_top = (XmlElement)Nguoi_dung.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
var Danh_sach_Nhom_Lap_top_cua_Nguoi_dung = Danh_sach_Nhom_Lap_top;
var Danh_sach_Lap_top_cua_Nguoi_dung = Danh_sach_Lap_top;
var Danh_sach_Nhan_vien_cua_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach_Nhan_vien(Danh_sach_Nguoi_dung, "BAN_HANG");
// Thống tin Online
Nguoi_dung_Dang_nhap = new XL_NGUOI_DUNG_DANG_NHAP();
//Tạo dữ liệu của Quản lý Bán hàng
Nguoi_dung_Dang_nhap.Danh_sach_Lap_top = Danh_sach_Lap_top_cua_Nguoi_dung;
Nguoi_dung_Dang_nhap.Danh_sach_Nhom_Lap_top = Danh_sach_Nhom_Lap_top_cua_Nguoi_dung;
Nguoi_dung_Dang_nhap.Danh_sach_Lap_top_Xem = Nguoi_dung_Dang_nhap.Danh_sach_Lap_top;
Nguoi_dung_Dang_nhap.Danh_sach_Nhan_vien_Ban_hang = Danh_sach_Nhan_vien_cua_Nguoi_dung;
//Tạo dữ liệu cho các nhân viên bán hàng
Nguoi_dung_Dang_nhap.Danh_sach_Nhan_vien_Ban_hang.ForEach(Nhan_vien =>
{
var DS_Nhom_Lap_top_NV = (XmlElement)Nhan_vien.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
var Danh_sach_Nhom_Lap_top_cua_Nhan_vien = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_Lap_top_NV, "Nhom_Lap_top");
var Doanh_thu = 0l;
Doanh_thu += Danh_sach_Nhom_Lap_top_cua_Nhan_vien.Sum(Nhom_Lap_top => long.Parse(Nhom_Lap_top.GetAttribute("Doanh_thu")));
Nhan_vien.SetAttribute("Doanh_thu", Doanh_thu.ToString());
});
HttpContext.Current.Session["Nguoi_dung_Dang_nhap"] = Nguoi_dung_Dang_nhap;
}
return(Nguoi_dung_Dang_nhap);
}
public string Ghi_Thay_doi_So_luong_Ton(XmlElement Danh_sach_Laptop_xml)
{
var Kq = $"<DU_LIEU Kq='OK'/>";
var count = 0;
foreach (XmlElement Laptop_xml in Danh_sach_Laptop_xml.GetElementsByTagName("Laptop"))
{
var Ma_so_Laptop = Laptop_xml.GetAttribute("Ma_so");
var So_luong = int.Parse(Laptop_xml.GetAttribute("So_luong"));
var Laptop = XL_NGHIEP_VU.Tim_Laptop(Ma_so_Laptop, Danh_sach_Laptop);
if (Laptop != null)
{
var So_luong_Ton = int.Parse(Laptop.GetAttribute("So_luong_Ton"));
So_luong_Ton += So_luong;
Laptop.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
}
else
{
Kq = $"<DU_LIEU Kq='ERROR_{Ma_so_Laptop}_DOESN'T_EXIST'/>";
break;
}
count++;
}
return(Kq);
}
public string Chon_Tinh_trang_Phieu_dat(string Ma_so_Tinh_trang)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)HttpContext.Current.Session["Nguoi_dung_Dang_nhap"];
Ma_so_Tinh_trang = Ma_so_Tinh_trang.ToUpper();
string chuoi_tra_cuu;
switch (Ma_so_Tinh_trang)
{
case "CHỜ GIAO HÀNG":
chuoi_tra_cuu = "CHO_GIAO_HANG";
break;
case "ĐÃ THANH TOÁN":
chuoi_tra_cuu = "DA_THANH_TOAN";
break;
case "HỦY":
chuoi_tra_cuu = "HUY";
break;
default:
chuoi_tra_cuu = Ma_so_Tinh_trang;
break;
}
Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat_Xem = XL_NGHIEP_VU.Tra_cuu_Phieu_dat(
chuoi_tra_cuu, Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat);
var Chuoi_HTML = Tao_Chuoi_HTML_Ket_qua();
return(Chuoi_HTML);
}
public string Cap_nhat_Don_gia_Ban(string Ma_so_San_pham, string Chuoi_Don_gia_Ban)
{
var San_pham = XL_NGHIEP_VU.Tim_San_pham(Ma_so_San_pham, Du_lieu_Dich_vu);
var Don_gia_Ban = long.Parse(Chuoi_Don_gia_Ban);
var Chuoi_Kq_Ghi = XL_LUU_TRU.Cap_nhat_Don_gia_Ban(San_pham, Don_gia_Ban);
var Chuoi_Xml_Kq = $"<DU_LIEU Kq='{Chuoi_Kq_Ghi}' />";
return(Chuoi_Xml_Kq);
}
public string Chon_Nhom_Lap_top(string Ma_so_Nhom_Lap_top)
{
var Khach_Tham_quan = (XL_KHACH_THAM_QUAN)HttpContext.Current.Session["Khach_Tham_quan"];
Khach_Tham_quan.Danh_sach_Lap_top_Xem = XL_NGHIEP_VU.Tra_cuu_Lap_top(Ma_so_Nhom_Lap_top, Khach_Tham_quan.Danh_sach_Lap_top);
var Chuoi_HTML = Tao_Chuoi_HTML_Ket_qua();
return(Chuoi_HTML);
}
public string Tra_cuu_Nguoi_dung(string Chuoi_Tra_cuu)
{
var Danh_sach_Nguoi_dung_Xem = XL_NGHIEP_VU.Tra_cuu_Nguoi_dung_Dang_nhap(Chuoi_Tra_cuu, Danh_sach_Nguoi_dung);
var Chuoi_HTML = $"<div>" +
$"{XL_THE_HIEN.Tao_Chuoi_HTML_Danh_sach_Nguoi_dung_Xem(Danh_sach_Nguoi_dung_Xem)}" +
$"</div>";
return(Chuoi_HTML);
}
void Khoi_dong_Du_lieu_cua_Dich_vu()
{
var Du_lieu_Luu_tru = XL_LUU_TRU.Doc_Du_lieu();
var Chuoi_XML = Du_lieu_Luu_tru.OuterXml;
var Tai_lieu = new XmlDocument();
Tai_lieu.LoadXml(Chuoi_XML);
Du_lieu_Dich_vu = Tai_lieu.DocumentElement;
var Danh_sach_San_pham = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Danh_sach_San_pham")[0];
var Cua_hang = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Cua_hang")[0];
var Danh_sach_Nhom_San_pham = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
var Danh_sach_Phieu_dat = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Danh_sach_Phieu_dat")[0];
var Tong_Doanh_thu_Ngay_hien_hanh = 0.0;
var Tong_Doanh_thu_Thang_hien_hanh = 0.0;
var Tong_Doanh_thu_Nam_hien_hanh = 0.0;
var Tong_So_luong_ton = 0.0;
// ===================== Bổ sung thông tin ===============================
foreach (XmlElement San_pham in Danh_sach_San_pham.GetElementsByTagName("San_pham"))
{
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_San_pham(San_pham);
San_pham.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_San_pham(San_pham, DateTime.Today);
San_pham.SetAttribute("Doanh_thu", Doanh_thu.ToString());
var Doanh_thu_Thang_hien_hanh = XL_NGHIEP_VU.Tinh_Doanh_thu_San_pham_Thang_hien_hanh(San_pham, DateTime.Today);
var Doanh_thu_Nam_hien_hanh = XL_NGHIEP_VU.Tinh_Doanh_thu_San_pham_Thang_hien_hanh(San_pham, DateTime.Today);
Tong_So_luong_ton += So_luong_Ton;
Tong_Doanh_thu_Ngay_hien_hanh += Doanh_thu;
Tong_Doanh_thu_Thang_hien_hanh += Doanh_thu_Thang_hien_hanh;
Tong_Doanh_thu_Nam_hien_hanh += Doanh_thu_Nam_hien_hanh;
}
foreach (XmlElement Nhom_San_pham in Danh_sach_Nhom_San_pham.GetElementsByTagName("Nhom_San_pham"))
{
var Danh_sach_San_pham_cua_Nhom_San_pham = XL_NGHIEP_VU.Tao_Danh_sach_San_pham_cua_Nhom_San_pham(Nhom_San_pham, Danh_sach_San_pham);
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_San_pham(Danh_sach_San_pham_cua_Nhom_San_pham);
Nhom_San_pham.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_San_pham(Danh_sach_San_pham_cua_Nhom_San_pham, DateTime.Today);
Nhom_San_pham.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
foreach (XmlElement Nguoi_dung in Danh_sach_Nguoi_dung.GetElementsByTagName("Nguoi_dung"))
{
foreach (XmlElement Nhom_San_pham in Nguoi_dung.SelectNodes("Danh_sach_Nhom_San_pham/Nhom_San_pham"))
{
var Danh_sach_San_pham_cua_Nhom_San_pham = XL_NGHIEP_VU.Tao_Danh_sach_San_pham_cua_Nhom_San_pham(Nhom_San_pham, Danh_sach_San_pham);
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_San_pham(Danh_sach_San_pham_cua_Nhom_San_pham);
Nhom_San_pham.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_San_pham(Danh_sach_San_pham_cua_Nhom_San_pham, DateTime.Today);
Nhom_San_pham.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
}
Cua_hang.SetAttribute("Tong_So_luong_ton", Tong_So_luong_ton.ToString());
Cua_hang.SetAttribute("Tong_Doanh_thu_Ngay_hien_hanh", Tong_Doanh_thu_Ngay_hien_hanh.ToString());
Cua_hang.SetAttribute("Tong_Doanh_thu_Thang_hien_hanh", Tong_Doanh_thu_Thang_hien_hanh.ToString());
Cua_hang.SetAttribute("Tong_Doanh_thu_Nam_hien_hanh", Tong_Doanh_thu_Nam_hien_hanh.ToString());
}
public string Chon_Nhom_San_pham(string Ma_so_San_pham)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)HttpContext.Current.Session["Nguoi_dung_Dang_nhap"];
Nguoi_dung_Dang_nhap.Danh_sach_San_pham_Xem = XL_NGHIEP_VU.Tra_cuu_San_pham(
Ma_so_San_pham, Nguoi_dung_Dang_nhap.Danh_sach_San_pham);
var Chuoi_HTML = Tao_Chuoi_HTML_Ket_qua();
return(Chuoi_HTML);
}
public string Tra_cuu(string Chuoi_Tra_cuu)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)HttpContext.Current.Session["Nguoi_dung_Dang_nhap"];
Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat_Xem = XL_NGHIEP_VU.Tra_cuu_Phieu_dat(
Chuoi_Tra_cuu, Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat);
var Chuoi_HTML = Tao_Chuoi_HTML_Ket_qua();
return(Chuoi_HTML);
}
void Khoi_dong_Du_lieu_Ung_dung()
{
Cua_hang = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Cua_hang")[0];
var DS_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
Danh_sach_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nguoi_dung, "Nguoi_dung");
var DS_Phieu_dat = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Danh_sach_Phieu_dat")[0];
Danh_sach_Phieu_dat = XL_NGHIEP_VU.Tao_Danh_sach(DS_Phieu_dat, "PHIEU_DAT");
}
public string Chon_Nhom_San_pham(string Ma_so_Nhom_San_pham)
{
var Danh_sach_San_pham_Xem = XL_NGHIEP_VU.Tra_cuu_San_pham(Ma_so_Nhom_San_pham, Danh_sach_San_pham);
var Danh_sach_Nhom_San_pham_Xem = Danh_sach_Nhom_San_pham;
var Chuoi_HTML = $"<div>" +
$"{XL_THE_HIEN.Tao_Chuoi_HTML_Danh_sach_Nhom_San_pham_Xem(Danh_sach_Nhom_San_pham_Xem)}" +
$"{XL_THE_HIEN.Tao_Chuoi_HTML_Danh_sach_San_pham_Xem(Danh_sach_San_pham_Xem)}" +
$"</div>";
return(Chuoi_HTML);
}
public void Update_So_luong_ton()
{
Danh_sach_Laptop_Chon.ForEach(Laptop_chon =>
{
string Ma_so = Laptop_chon.GetAttribute("Ma_so");
var Laptop = XL_NGHIEP_VU.Tim_Laptop(Ma_so, Danh_sach_Laptop);
int So_luong_ton = int.Parse(Laptop.GetAttribute("So_luong_ton"));
int So_luong = int.Parse(Laptop_chon.GetAttribute("So_luong"));
So_luong_ton -= So_luong;
Laptop.SetAttribute("So_luong_ton", So_luong_ton.ToString());
});
}
void Khoi_dong_Du_lieu_Ung_dung()
{
Cua_hang = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Cong_ty")[0];
var DS_Nhom_Lap_top = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
Danh_sach_Nhom_Lap_top = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_Lap_top, "Nhom_Lap_top");
var DS_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
Danh_sach_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nguoi_dung, "Nguoi_dung");
var DS_Lap_top = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Danh_sach_Lap_top")[0];
Danh_sach_Lap_top = XL_NGHIEP_VU.Tao_Danh_sach(DS_Lap_top, "Laptop");
}
void Khoi_dong_Du_lieu_Ung_dung()
{
Cua_hang = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Cua_hang")[0];
var DS_Nhom_San_pham = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nhom_San_pham")[0];
Danh_sach_Nhom_San_pham = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nhom_San_pham, "Nhom_San_pham");
var DS_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
Danh_sach_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nguoi_dung, "Nguoi_dung");
var DS_San_pham = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Danh_sach_San_pham")[0];
Danh_sach_San_pham = XL_NGHIEP_VU.Tao_Danh_sach(DS_San_pham, "San_pham");
}
public string Cap_nhat_don_gia_ban(string Ma_so_Lap_top, string Don_gia_ban)
{
var Lap_top = XL_NGHIEP_VU.Tim_Laptop(Ma_so_Lap_top, Du_lieu_Dich_vu);
var Chuoi_Kq_Ghi = XL_LUU_TRU.Cap_nhat_Don_gia_ban(Lap_top, Don_gia_ban);
if (Chuoi_Kq_Ghi == "OK")
{
Lap_top.SetAttribute("Don_gia_ban", Don_gia_ban);
}
var Chuoi_Xml_Kq = $"<DU_LIEU Kq='{Chuoi_Kq_Ghi}' />";
return(Chuoi_Xml_Kq);
}
public string Tra_cuu(string Chuoi_Tra_cuu)
{
var Danh_sach_San_pham_Xem = XL_NGHIEP_VU.Tra_cuu_San_pham(Chuoi_Tra_cuu, Danh_sach_San_pham);
var Danh_sach_Nhom_San_pham_Xem = Danh_sach_Nhom_San_pham;
var Danh_sach_Nhan_vien_Nhap_hang = Danh_sach_Nguoi_dung;
var Chuoi_HTML = $"<div>" +
$"{XL_THE_HIEN.Tao_Chuoi_HTML_Danh_sach_Nhom_San_pham_Xem(Danh_sach_Nhom_San_pham_Xem)}" +
$"{XL_THE_HIEN.Tao_Chuoi_HTML_Danh_sach_Nhom_Nhan_vien_Nhap_hang(Danh_sach_Nhan_vien_Nhap_hang)}" +
$"{XL_THE_HIEN.Tao_Chuoi_HTML_Danh_sach_San_pham_Xem(Danh_sach_San_pham_Xem)}" +
$"</div>";
return(Chuoi_HTML);
}
public string Ghi_Giao_hang(string Ma_so_Phieu_dat)
{
var Phieu_dat = XL_NGHIEP_VU.Tim_Phieu_dat(Ma_so_Phieu_dat, Du_lieu_Dich_vu);
var Chuoi_Kq_Ghi = XL_LUU_TRU.Ghi_Giao_hang(Phieu_dat);
if (Chuoi_Kq_Ghi == "OK")
{
Phieu_dat.SetAttribute("Trang_thai", "DA_GIAO_HANG");
}
var Chuoi_Xml_Kq = $"<DU_LIEU Kq='{Chuoi_Kq_Ghi}' />";
return(Chuoi_Xml_Kq);
}
void Khoi_dong_Du_lieu_Ung_dung()
{
Cong_ty = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Cong_ty")[0];
var DS_Nguoi_dung = (XmlElement)Cong_ty.GetElementsByTagName("Danh_sach_Nhan_vien")[0];
Danh_sach_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(DS_Nguoi_dung, "Quan_ly");
var DS_Phieu_dat = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Danh_sach_Phieu_dat")[0];
Danh_sach_Phieu_dat = XL_NGHIEP_VU.Tao_Danh_sach_Phieu_dat(DS_Phieu_dat);
var DS_Tinh_trang = (XmlElement)Du_lieu_Ung_dung.GetElementsByTagName("Danh_sach_Tinh_trang_Phieu_dat")[0];
Danh_sach_Tinh_trang_Phieu_dat = XL_NGHIEP_VU.Tao_Danh_sach(DS_Tinh_trang, "Tinh_trang");
}
public string Chon_Nhan_vien_Phieu_dat(string Ma_so_Nhan_vien)
{
var Nguoi_dung_Dang_nhap = (XL_NGUOI_DUNG_DANG_NHAP)HttpContext.Current.Session["Nguoi_dung_Dang_nhap"];
string chuoi_tra_cuu = Ma_so_Nhan_vien;
Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat_Xem = XL_NGHIEP_VU.Tra_cuu_Phieu_dat(
chuoi_tra_cuu, Nguoi_dung_Dang_nhap.Danh_sach_Phieu_dat, true);
var Chuoi_HTML = Tao_Chuoi_HTML_Ket_qua();
return(Chuoi_HTML);
}
public string Ghi_Thay_doi_So_luong_Ton(string Ma_so_Laptop, string So_luong_Ton)
{
var Laptop = XL_NGHIEP_VU.Tim_Laptop(Ma_so_Laptop, Danh_sach_Laptop);
if (Laptop != null)
{
Laptop.SetAttribute("So_luong_Ton", So_luong_Ton);
return($"<DU_LIEU Kq='OK' />");
}
else
{
return("<DU_LIEU Kq='ERROR_LAPTOP_DOESN'T_EXIST'/>");
}
}
public string Ghi_Ban_hang_Moi(string Ma_so_Lap_top, string Chuoi_Xml_Ban_hang)
{
var Lap_top = XL_NGHIEP_VU.Tim_Laptop(Ma_so_Lap_top, Du_lieu_Dich_vu);
var Ban_hang = XL_NGHIEP_VU.Tao_Doi_tuong_Con(Chuoi_Xml_Ban_hang, Lap_top);
var Chuoi_Kq_Ghi = XL_LUU_TRU.Ghi_Ban_hang_Moi(Lap_top, Ban_hang);
if (Chuoi_Kq_Ghi == "OK")
{
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_ton_Laptop(Lap_top);
Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
}
var Chuoi_Xml_Kq = $"<DU_LIEU Kq='{Chuoi_Kq_Ghi}' />";
return(Chuoi_Xml_Kq);
}
public string Ghi_Phan_cong(string Ma_so_Phieu_dat, string Ma_Nhan_vien_Giao_hang)
{
var Phieu_dat = XL_NGHIEP_VU.Tim_Phieu_dat(Ma_so_Phieu_dat, Du_lieu_Dich_vu);
var Nhan_vien_Giao_hang = (XmlElement)Phieu_dat.SelectNodes("Nhan_vien_Giao_hang")[0];
var Chuoi_Kq_Ghi = XL_LUU_TRU.Ghi_Phan_cong(Phieu_dat);
if (Chuoi_Kq_Ghi == "OK")
{
Phieu_dat.SetAttribute("Trang_thai", "CHO_GIAO_HANG");
Nhan_vien_Giao_hang.SetAttribute("Ma_so", Ma_Nhan_vien_Giao_hang);
}
var Chuoi_Xml_Kq = $"<DU_LIEU Kq='{Chuoi_Kq_Ghi}' />";
return(Chuoi_Xml_Kq);
}
