private void frmQuanLySanPham_Load(object sender, EventArgs e)
{
cmbDanhMuc.DataSource = DanhMucBUS.GetList();
cmbDanhMuc.DisplayMember = "TenDanhMuc";
cmbDanhMuc.ValueMember = "MaDanhMuc";
cmbTrangThai.Text = "Tất cả trạng thái";
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtTenDanhMuc.Text.Length == 0)
{
MessageBox.Show("Bạn Chưa Nhập Tên Danh Mục!", "Cảnh báo!");
}
else
{
DanhMucDTO danhMuc = new DanhMucDTO();
danhMuc.TenDanhMuc = txtTenDanhMuc.Text;
DanhMucBUS.Insert(danhMuc);
MessageBox.Show("Thêm thành công!", "Thông báo!");
this.Refresh();
}
}
void treelist_ThemDanhMuc()
{
TreeNode all = new TreeNode();
all.Text = "Tất cả";
all.Tag = "Tất cả";
treedanhmuc.Nodes.Add(all);
List <DanhMucDTO> dm = DanhMucBUS.DanhMuc_List();
foreach (DanhMucDTO item in dm)
{
TreeNode node = new TreeNode();
node.Text = item.Dm_ten;
node.Tag = item.Dm_id.ToString();
treedanhmuc.Nodes.Add(node);
}
}
private void btnImport_Click(object sender, EventArgs e)
{
try
{
if (!rdNew.Checked && !rdUpdate.Checked)
{
MessageBox.Show("Please select type of import");
return;
}
SanPhamBUS spBus = new SanPhamBUS();
foreach (DataGridViewRow row in this.dtgvCvsData.Rows)
{
SanPhamDTO sp = new SanPhamDTO();
sp.MaSanPham = row.Cells["name"].Value.ToString();
if (row.Cells["image"].Value.ToString() != "")
{
string[] splitHinhAnh = row.Cells["image"].Value.ToString().Split('/');
if (splitHinhAnh.Length > 2)
{
sp.HinhAnh = splitHinhAnh[3];
}
else
{
sp.HinhAnh = row.Cells["image"].Value.ToString().Substring(2).ToLower();
}
}
else
{
sp.HinhAnh = "";
}
string[] splitTrongLuong = row.Cells["weight"].Value.ToString().Split('.');
sp.TrongLuong = Int32.Parse(splitTrongLuong[0]);
sp.MauSac = row.Cells["mau_sac"].Value.ToString();
string[] splitSoLuong = row.Cells["qty"].Value.ToString().Split('.');
//if (rdNew.Checked == true)
//{
// sp.SoLuong = 100;
//}
//else
//{
// sp.SoLuong = Int32.Parse(splitSoLuong[0]);
//}
sp.SoLuong = Int32.Parse(splitSoLuong[0]);
sp.TrangThai = Int32.Parse(row.Cells["is_in_stock"].Value.ToString());
string[] splitGiaLe = row.Cells["price"].Value.ToString().Split('.');
sp.GiaLe = long.Parse(splitGiaLe[0]);
string[] splitGiaSi = row.Cells["gia_si"].Value.ToString().Split('.');
sp.GiaSi = long.Parse(splitGiaSi[0]);
if (sp.GiaSi == 0)
{
double a = (sp.GiaLe / 3) * 2;
sp.GiaSi = (long)Math.Round(a);
}
sp.GiaGoc = sp.GiaSi / 2;
sp.NgayNhap = System.DateTime.Now;
sp.NguoiNhap = frmDangNhap.gUserName;
sp.NgayCapNhat = System.DateTime.Now;
sp.NguoiCapNhat = frmDangNhap.gUserName;
DanhMucBUS dmBUS = new DanhMucBUS();
if (sp.MaSanPham.Substring(0, 1) == "N")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Nhẫn").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 1) == "X")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Hình Xăm").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "BT")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Bông Tai").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "DC")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Dây Chuyền").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "VT")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Vòng Tay").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "DL")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Dây Lưng").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "BA")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Túi Xách").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "KT")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Phụ Kiện Tóc").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "CA")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Cài Áo").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "BK")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Bikini").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "DH")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Đồng Hồ").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "MK")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Móc Khóa").MaDanhMuc;
}
if (sp.MaSanPham.Substring(0, 2) == "KQ")
{
sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Khăn Quàng Cổ").MaDanhMuc;
}
if (spBus.KiemTraTonTai(sp.MaSanPham) == true)
{
spBus.Update(sp);
}
else
{
spBus.Insert(sp);
}
}
MessageBox.Show("Import dữ liệu thành công!", "Thông báo!");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
