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 static List <XmlElement> Tao_Danh_sach_Lap_top_cua_Nguoi_dung(
XmlElement Nguoi_dung, XmlElement Danh_sach_Tat_ca_Lap_top)
{
var Danh_sach = new List <XmlElement>();
var DS_Tat_ca_Lap_top = Tao_Danh_sach(Danh_sach_Tat_ca_Lap_top, "Laptop");
Danh_sach = DS_Tat_ca_Lap_top.FindAll(
Lap_top => Lap_top.SelectSingleNode("Nhom_Lap_top/@Ma_so").Value == Nguoi_dung.GetAttribute("Ma_so"));
return(Danh_sach);
}
public static XmlElement Tim_Lap_top(
string Ma_so, XmlElement Du_lieu)
{
var Danh_sach_Lap_top = (XmlElement)Du_lieu.GetElementsByTagName("Danh_sach_Lap_top")[0];
var Kq = (XmlElement)null;
foreach (XmlElement Lap_top in Danh_sach_Lap_top.GetElementsByTagName("Laptop"))
{
if (Ma_so == Lap_top.GetAttribute("Ma_so"))
{
Kq = Lap_top;
}
}
return(Kq);
}
public static string Tao_Chuoi_HTML_Danh_sach_Lap_top_Chon(List <XmlElement> Danh_sach)
{
var Chuoi_HTML_Danh_sach = "<div class='row'>";
var Chuoi_Chuc_nang_Dat_hang = $"<div style='margin-left:10px' ><form method='post'>" +
"<input name='Th_Ma_so_Chuc_nang' type='hidden' value='DAT_HANG' />" +
$"<button type='submit' class='btn btn-danger' >Đặt hàng</button>" +
"</form></div>";
if (Danh_sach.Count > 0)
{
Chuoi_HTML_Danh_sach += Chuoi_Chuc_nang_Dat_hang;
}
Danh_sach.ForEach(Lap_top =>
{
var Ten = Lap_top.GetAttribute("Ten");
var Ma_so = Lap_top.GetAttribute("Ma_so");
var Don_gia_Ban = long.Parse(Lap_top.GetAttribute("Don_gia_Ban"));
var So_luong_Ton = int.Parse(Lap_top.GetAttribute("So_luong_Ton"));
var So_luong = int.Parse(Lap_top.GetAttribute("So_luong"));
var Dinh_dang_Trang_thai = ""; var Chuoi_Trang_thai = "";
var Chuoi_Chuc_nang_Giam_So_luong = $"<form method='post'>" +
"<input name='Th_Ma_so_Chuc_nang' type='hidden' value='GIAM_SO_LUONG_LAP_TOP' />" +
$"<input name='Th_Ma_so_Lap_top' type='hidden' value='{Ma_so}' />" +
$"<button type='submit' class='btn btn-danger' >-</button>" +
"</form>";
var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{ Ma_so}.png' " +
"style='width:90px;height:90px;' />";
var Chuoi_Thong_tin = $"<div class='btn' style='text-align:left'> " +
$"{ Ten}" +
$"<br />Đơn giá Bán { Don_gia_Ban.ToString("n0", Dinh_dang_VN) }" +
$"<br />Số lượng Đặt { So_luong.ToString("n0", Dinh_dang_VN) }" +
$"<br />{ Chuoi_Trang_thai }" +
$"</div>";
var Chuoi_HTML = $"<div class='col-md-4' style='margin-bottom:10px;{Dinh_dang_Trang_thai}' >" +
$"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" +
$"{Chuoi_Chuc_nang_Giam_So_luong}" +
"</div>";
Chuoi_HTML_Danh_sach += Chuoi_HTML;
});
Chuoi_HTML_Danh_sach += "</div>";
return(Chuoi_HTML_Danh_sach);
}
public static string Tao_Chuoi_HTML_Danh_sach_Lap_top_Xem(List <XmlElement> Danh_sach)
{
var Chuoi_HTML_Danh_sach = "<div class='row'>";
Danh_sach.ForEach(Lap_top =>
{
var Ten = Lap_top.GetAttribute("Ten");
var Ma_so = Lap_top.GetAttribute("Ma_so");
var Don_gia_Ban = long.Parse(Lap_top.GetAttribute("Don_gia_Ban"));
var So_luong_Ton = int.Parse(Lap_top.GetAttribute("So_luong_Ton"));
var Dinh_dang_Trang_thai = ""; var Chuoi_Trang_thai = "";
var Chuoi_Chuc_nang_Chon = $"<form method='post'>" +
"<input name='Th_Ma_so_Chuc_nang' type='hidden' value='CHON_LAP_TOP' />" +
$"<input name='Th_Ma_so_Lap_top' type='hidden' value='{Ma_so}' />" +
$"<button type='submit' class='btn btn-danger' >Chọn</button>" +
"</form>";
if (So_luong_Ton == 0)
{
Dinh_dang_Trang_thai = ";opacity:0.7";;
Chuoi_Trang_thai = "Tạm thời hết hàng";
Chuoi_Chuc_nang_Chon = "";
}
var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{ Ma_so}.png' " +
"style='width:90px;height:90px;' />";
var Chuoi_Thong_tin = $"<div class='btn' style='text-align:left'> " +
$"<div style='width:300px;white-space: nowrap;overflow: hidden;text-overflow: ellipsis;'>{ Ten}" +
$"</div>" +
$"Đơn giá Bán { Don_gia_Ban.ToString("n0", Dinh_dang_VN) }" +
$"<br />{ Chuoi_Trang_thai }" +
$"</div>";
var Chuoi_HTML = $"<div class='col-md-4' style='margin-bottom:10px;{Dinh_dang_Trang_thai}' >" +
$"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" +
$"{Chuoi_Chuc_nang_Chon}" +
"</div>";
Chuoi_HTML_Danh_sach += Chuoi_HTML;
});
Chuoi_HTML_Danh_sach += "</div>";
return(Chuoi_HTML_Danh_sach);
}
public static string Tao_Chuoi_HTML_Danh_sach_Lap_top_Xem(List <XmlElement> Danh_sach)
{
var Chuoi_HTML_Danh_sach = "<div class='row'>";
Danh_sach.ForEach(Lap_top =>
{
var Ten = Lap_top.GetAttribute("Ten");
var Ma_so = Lap_top.GetAttribute("Ma_so");
var Don_gia_Ban = long.Parse(Lap_top.GetAttribute("Don_gia_Ban"));
var So_luong_Ton = int.Parse(Lap_top.GetAttribute("So_luong_Ton"));
var Doanh_thu = long.Parse(Lap_top.GetAttribute("Doanh_thu"));
var Dinh_dang_Trang_thai = "";
if (So_luong_Ton == 0)
{
Dinh_dang_Trang_thai = ";opacity:0.7";;
}
var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{ Ma_so}.png' " +
"style='width:90px;height:90px;' />";
var Chuoi_Thong_tin = $"<div class='btn' style='text-align:left'> " +
$"<div style='width:300px;white-space: nowrap;overflow: hidden;text-overflow: ellipsis;'>{ Ten}" +
$"</div>" +
$"Đơn giá Bán { Don_gia_Ban.ToString("n0", Dinh_dang_VN) }" +
$"<br />Số lượng Tồn { So_luong_Ton.ToString("n0", Dinh_dang_VN) }" +
$"<br />Doanh thu { Doanh_thu.ToString("n0", Dinh_dang_VN) }" +
$"</div>";
var Chuoi_Chuc_nang_Ban_hang = $"<form method='post'> " +
$"<input name='Th_Ma_so_Chuc_nang' type='hidden' value='GHI_BAN_HANG_MOI' /> " +
$"<input name='Th_Ma_so_Lap_top' type='hidden' value='{Ma_so}' /> " +
$"<input name='Th_So_luong' required='required' autocomplete='off' " +
$"style='border:none;border-bottom:solid 1px blue'" +
$"type='number' min='1' max='100' value='10' /> " +
$"</form>";
var Chuoi_HTML = $"<div class='col-md-4' style='margin-bottom:10px;{Dinh_dang_Trang_thai}' >" +
$"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" +
$"{Chuoi_Chuc_nang_Ban_hang}" +
"</div>";
Chuoi_HTML_Danh_sach += Chuoi_HTML;
});
Chuoi_HTML_Danh_sach += "</div>";
return(Chuoi_HTML_Danh_sach);
}
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_Lap_top = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Danh_sach_Lap_top")[0];
var Cua_hang = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Cong_ty")[0];
var Danh_sach_Nhom_Lap_top = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0];
var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0];
// ===================== Bổ sung thông tin ===============================
foreach (XmlElement Lap_top in Danh_sach_Lap_top.GetElementsByTagName("Laptop"))
{
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Lap_top(Lap_top);
Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Lap_top(Lap_top, DateTime.Today);
Lap_top.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
foreach (XmlElement Nhom_Lap_top in Danh_sach_Nhom_Lap_top.GetElementsByTagName("Nhom_Lap_top"))
{
var Danh_sach_Lap_top_cua_Nhom_Lap_top = XL_NGHIEP_VU.Tao_Danh_sach_Lap_top_cua_Nhom_Lap_top(Nhom_Lap_top, Danh_sach_Lap_top);
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top);
Nhom_Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top, DateTime.Today);
Nhom_Lap_top.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
foreach (XmlElement Nguoi_dung in Danh_sach_Nguoi_dung.GetElementsByTagName("Nguoi_dung"))
{
foreach (XmlElement Nhom_Lap_top in Nguoi_dung.SelectNodes("Danh_sach_Nhom_Lap_top/Nhom_Lap_top"))
{
var Danh_sach_Lap_top_cua_Nhom_Lap_top = XL_NGHIEP_VU.Tao_Danh_sach_Lap_top_cua_Nhom_Lap_top(Nhom_Lap_top, Danh_sach_Lap_top);
var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top);
Nhom_Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString());
var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top, DateTime.Today);
Nhom_Lap_top.SetAttribute("Doanh_thu", Doanh_thu.ToString());
}
}
}
public XmlElement Tao_Du_lieu_cua_Ung_dung_Khach_Tham_quan()
{
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];
//Cua_hang.RemoveChild(Danh_sach_Nguoi_dung);
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);
}
//============= Xử lý Chức năng ========
public string Ghi_Phieu_Dat_hang_Moi(string Ho_ten, string Dia_chi, string Dien_thoai, XL_KHACH_THAM_QUAN Khach)
{
var Chuoi_XML = "<PHIEU_DAT />";
var Tai_lieu = new XmlDocument();
Tai_lieu.LoadXml(Chuoi_XML);
var Phieu_dat = Tai_lieu.DocumentElement;
Phieu_dat.SetAttribute("Ma_so", "");
Phieu_dat.SetAttribute("Ngay", DateTime.Now.ToString());
Phieu_dat.SetAttribute("Trang_thai", "CHUA_GIAO_HANG");
var Khach_hang = (Tai_lieu.CreateElement("Khach_hang"));
Khach_hang.SetAttribute("Ho_ten", Ho_ten);
Khach_hang.SetAttribute("Dien_thoai", Dien_thoai);
Khach_hang.SetAttribute("Dia_chi", Dia_chi);
Phieu_dat.AppendChild(Khach_hang);
var Ds = Tai_lieu.CreateElement("Danh_sach_Lap_top");
Phieu_dat.AppendChild(Ds);
Khach.Danh_sach_Lap_top_Chon.ForEach(Lap_top =>
{
var QA = Tai_lieu.CreateElement("Laptop");
QA.SetAttribute("Ma_so", Lap_top.GetAttribute("Ma_so"));
QA.SetAttribute("Ten", Lap_top.GetAttribute("Ten"));
var Nhom_Lap_top = Tai_lieu.CreateElement("Nhom_Lap_top");
Nhom_Lap_top.SetAttribute("Nhom_Lap_top", Lap_top.SelectSingleNode("Nhom_Lap_top/@Ma_so").Value);
QA.AppendChild(Nhom_Lap_top);
var Don_Gia = long.Parse(Lap_top.GetAttribute("Don_gia_Ban"));
var So_luong = long.Parse(Lap_top.GetAttribute("So_luong"));
var Tien = Don_Gia * So_luong;
QA.SetAttribute("Don_gia", Lap_top.GetAttribute("Don_gia_Ban"));
QA.SetAttribute("So_luong", Lap_top.GetAttribute("So_luong"));
QA.SetAttribute("Tien", Tien.ToString());
Ds.AppendChild(QA);
/*var tailieu = new XmlDocument();
* tailieu.LoadXml(Lap_top.OuterXml);
* tailieu.remoa
* var Lap_top1 = tailieu.DocumentElement;
* var Lap_top2 = Tai_lieu.ImportNode(Lap_top1, true);
* Ds.AppendChild(Lap_top2);*/
});
Phieu_dat.AppendChild(Ds);
var Kq_Ghi = XL_LUU_TRU.Ghi_Phieu_Dat_hang_moi(Phieu_dat);
Khach.Thong_bao = "";
if (Kq_Ghi == "OK")
{
Khach.Thong_bao = "Đặt phiếu Thành công";
Khach.Danh_sach_Lap_top_Chon = new List <XmlElement>();
}
else
{
Khach.Thong_bao = "Lỗi Hệ thống - Xin Thực hiện lại ";
}
var Chuoi_HTML = XL_THE_HIEN.Tao_chuoi_HTML_Thong_bao(Khach.Thong_bao);
return(Chuoi_HTML);
}
