private void LoadInfo(int id)
{
ProductBUS bus = new ProductBUS();
ProductDTO result = bus.LoadOneProduct(id);
txtID.Content = result.ID.ToString();
txtName.Text = result.Name;
lblAmount.Content = result.IvenNum.ToString();
txtInputPrice.Text = result.InputPrice.ToString();
txtOutputPrice.Text = result.OutputPrice.ToString();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
String productId = dataGridView1.Rows[e.RowIndex].Cells["id"].Value.ToString();
Product product = ProductBUS.searchById(productId);
txtId.Text = product.id.ToString();
txtName.Text = product.name.ToString();
txtCateId.Text = product.cateid.ToString();
txtPrice.Text = product.price.ToString();
txtDesc.Text = product.description.ToString();
txtImageLink.Text = product.imagelink.ToString();
}
public object Get(string name)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), null, Level.INFO);
ResponseDTO Response = new ResponseDTO();
Response = ProductBUS.GetAllProduct(name);
return(Response);
}
private void FrmPosFunction_Load(object sender, EventArgs e)
{
ResizeWindows();
productBUS = new ProductBUS();
lstProduct = productBUS.GetAll();
lstOrderProduct = new List <Product>();
lstOrderQuantity = new List <int>();
LoadDanhSachSanPham();
ResetForm();
}
private void ThemChiTietSanPham_Load(object sender, EventArgs e)
{
ProductBUS productBUS = new ProductBUS();
cbTenHang.DataSource = productBUS.LoadAllData();
cbTenHang.DisplayMember = "Name";
cbTenHang.ValueMember = "ProductID";
UnitBUS unitBUS = new UnitBUS();
cbDonVi.DataSource = unitBUS.LoadAllData();
cbDonVi.ValueMember = "UnitID";
cbDonVi.DisplayMember = "Name";
}
// GET: Admin/Product/Delete/5
public ActionResult Delete(int id)
{
var info = new ProductInfoAdmin()
{
SanPhamInfoAdmim = ProductBUS.ProductDetail(id),
TenLoaiSanPham = ProductBUS.GetTenLoaiSanPham(id),
TenNhaCungCap = ProductBUS.GetTenNhaCungCap(id),
TenNhaSanXuat = ProductBUS.GetTenNhaSanXuat(id)
};
return(View(info));
//var sp = ProductBUS.ProductDetail(id);
//return View(sp);
}
public AddProductForm(
BindingSource productTypeBindingSource,
BindingSource supplierBindingSource,
BindingSource productBrandBindingSource
)
{
InitializeComponent();
selectedProductTypes = new ObservableListSource <ProductType>();
selectedSuppliers = new ObservableListSource <Supplier>();
bus = new ProductBUS();
productBrandBindingSource_All.DataSource = productBrandBindingSource.DataSource;
productTypeBindingSource_All.DataSource = productTypeBindingSource.DataSource;
supplierBindingSource_All.DataSource = supplierBindingSource.DataSource;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["ml"] != null)
{
int type = 0;
int.TryParse(Request.QueryString["ml"].ToString(), out type);
List <SAN_PHAM_DTO> list = ProductBUS.GetProductsFollowType(type);
if (list.Count <= 0)
{
idh4.InnerHtml = "Chưa có sản phẩm nào!";
}
DataList1.DataSource = list;
DataList1.DataBind();
switch (type)
{
case 1:
lb.InnerHtml = "VẬT LIỆU THÔ";
break;
case 2:
lb.InnerHtml = "VẬT LIỆU HOÀN THIỆN";
break;
case 3:
lb.InnerHtml = "HỆ THỐNG ỐNG VÀ PHỤ KIỆN";
break;
case 4:
lb.InnerHtml = "VẬT LIỆU ĐẶT BIỆT";
break;
case 5:
lb.InnerHtml = "ĐỒ NỘI THẤT TRONG NHÀ";
break;
case 6:
lb.InnerHtml = "THIẾT BỊ NHÀ TẮM - VỆ SINH";
break;
case 7:
lb.InnerHtml = "THIẾT BỊ NHÀ BẾP";
break;
}
}
}
}
void DelProduct(int idProduct, string name, int idCat)
{
if (MessageBox.Show("Bạn đã chắc chắn muốn xóa " + name + " chưa?", "Thông báo", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
bool result = new ProductBUS().DelProduct(idProduct);
if (result)
{
GetCatProToppingByIdCat(idCat);
namePro = "";
MessageBox.Show("Xóa thành công :3", "Thông báo");
}
else
{
MessageBox.Show("Xóa thất bại :(", "Thông báo");
}
}
}
public Manage()
{
InitializeComponent();
sorter = new ListViewColumnSorter();
lvCatalog.ListViewItemSorter = sorter;
lvCombo.ListViewItemSorter = sorter;
lvProduct.ListViewItemSorter = sorter;
lvBill.ListViewItemSorter = sorter;
accountBUS = new AccountBUS();
billBUS = new BillBUS();
billDetailBUS = new BillDetailBUS();
catalogBUS = new CatalogBUS();
comboBUS = new ComboBUS();
comboDetailBUS = new ComboDetailBUS();
productBUS = new ProductBUS();
}
private void FilterProduct()
{
if (cbLoaiThucUong.SelectedIndex >= 0 && cbxProductSizes.SelectedIndex >= 0)
{
if (cbLoaiThucUong.SelectedItem == null || cbxProductSizes.SelectedItem == null)
{
return;
}
var typeProduct = cbLoaiThucUong.SelectedItem as TypeProductDTO;
var typeId = typeProduct.ID;
var size = cbxProductSizes.SelectedItem as ProductSize;
var sizeId = size.Id;
LoadProductListByTypeProductID(ProductBUS.GetListProductByIDTypeProduct(typeId, 1, sizeId));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
List <SAN_PHAM_DTO> list = ProductBUS.SelectTopNewProducts();
DataList1.DataSource = list;
DataList1.DataBind();
/* string strProduct = "<table class='tbproduct'>";
* int n = list.Count;
* int m=Min(3,n);
* strProduct += AddListProducts(0,list, m);
* m = Min(6, n);
* strProduct += AddListProducts(3,list, m);
* m = Min(9, n);
* strProduct += AddListProducts(6,list, m);
* strProduct += "</table>";
* divNewProduce.InnerHtml = strProduct;*/
/*
*
* <td class='produce'>
* <asp:LinkButton ID='lbtProduce' runat='server'>
* <img src='../../Content/images/bep-karador.jpg' />
* <img src='../../Content/images/new.gif' />
* <br />
*
* </asp:LinkButton>
* <label id='lbName' class='lbname' runat='server'>Bếp ga Karador</label><br />
* <label id='lbSaleOff' runat='server'>Giảm giá : 0%</label><br />
* <label class='label' id='lbPrice' runat='server'>Giá : 5000000 VNĐ/sp</label>
*
* <asp:LinkButton ID='LinkButton3' runat='server'>
* <img src='../../Content/images/xemchitiet_but.gif' />
* </asp:LinkButton>
*
* </td>
*
* </asp:LinkButton>
*
*
* </td>
*/
}
}
private void save_Click(object sender, EventArgs e)
{
ProductInfo product = new ProductInfo();
product.ProductName = txtTen.Text;
product.Price = int.Parse(txtGia.Text);
product.Image = image;
product.Quantity = int.Parse(txtSoLuong.Text);
product.UnitID = int.Parse(cbxDonvi.SelectedValue.ToString());
product.Description = txtMota.Text;
product.ProductName = txtTen.Text;
product.SupplierID = int.Parse(cbxNhacungcap.SelectedValue.ToString());
product.WarehouseID = int.Parse(cbxKho.SelectedValue.ToString());
product.Code = txtMa.Text;
ProductBUS productBUS = new ProductBUS();
productBUS.AddProduct(product);
}
private void frm_YeuCauGoiThucUong_Load(object sender, EventArgs e)
{
LoadProductSize();
LoadProductListByTypeProductID(ProductBUS.GetListProductByIDTypeProduct(0, 1));
cbLoaiThucUong.ContextMenu = new ContextMenu();
timer1.Enabled = true;
btnThanhToan.Enabled = false;
btnTamTinh.Enabled = false;
lstBillNoPayment.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
lstBillNoPayment.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
lstProductCart.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
lstProductCart.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
lstProduct.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
lstProduct.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
private void LoadProducts()
{
ProductBUS bus = new ProductBUS();
List <ProductDisplay> list = new List <ProductDisplay>();
List <ProductDTO> products = bus.LoadAllProduct();
for (int i = 0; i < products.Count(); i++)
{
list.Add(new ProductDisplay()
{
id = products[i].ID, name = products[i].Name, inputprice = products[i].InputPrice, outputprice = products[i].OutputPrice
});
}
listProduct.ItemsSource = list;
CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(listProduct.ItemsSource);
view.Filter = UserFilter;
}
private void btnImport_Clicked(object sender, RoutedEventArgs e)
{
if (txtAmount.Text.Count() == 0 || btnProduct.Content.ToString().Count() == 0 || btnSuplier.Content.ToString().Count() == 0)
{
lblNotice.Content = "Please fill all information.";
lblNotice.Visibility = Visibility.Visible;
return;
}
int amount;
bool isNumeric = Int32.TryParse(txtAmount.Text, out amount);
if (!isNumeric)
{
lblNotice.Content = "Amount isn't number!";
lblNotice.Visibility = Visibility.Visible;
return;
}
ProductBUS bus = new ProductBUS();
ProductDTO result = bus.LoadOneProduct(Global.IDProduct);
result.IvenNum = result.IvenNum + amount;
bus.UpdateProduct(result);
ImportDTO import = new ImportDTO();
import.Product = Int32.Parse(btnProduct.Content.ToString());
import.Suplier = Int32.Parse(btnSuplier.Content.ToString());
import.Amount = amount;
import.Total = amount * result.InputPrice;
import.DateInput = lblDate.Content.ToString();
ImportBUS importBUS = new ImportBUS();
importBUS.AddNewImport(import);
this.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
List <SAN_PHAM_DTO> list = ProductBUS.SelectModifyNewProducts();
DataList1.DataSource = list;
DataList1.DataBind();
/* string strProduct = "<table class='tbproduct'>";
* int n = list.Count;
* int m = Min(3, n);
* strProduct += AddListProducts(0, list, m);
* m = Min(6, n);
* strProduct += AddListProducts(3, list, m);
* m = Min(9, n);
* strProduct += AddListProducts(6, list, m);
* strProduct += "</table>";
* divNewProduce.InnerHtml = strProduct*/
}
}
private void btnSave_Clicked(object sender, RoutedEventArgs e)
{
if (txtName.Text.Count() == 0 || txtInputPrice.Text.Count() == 0 || txtOutputPrice.Text.Count() == 0)
{
lblNotice.Content = "Please fill all information.";
lblNotice.Visibility = Visibility.Visible;
return;
}
int temp;
bool isNumeric = Int32.TryParse(txtInputPrice.Text, out temp);
if (!isNumeric)
{
lblNotice.Content = "Input price isn't number!";
lblNotice.Visibility = Visibility.Visible;
return;
}
isNumeric = Int32.TryParse(txtOutputPrice.Text, out temp);
if (!isNumeric)
{
lblNotice.Content = "Output price isn't number!";
lblNotice.Visibility = Visibility.Visible;
return;
}
ProductBUS bus = new ProductBUS();
ProductDTO result = new ProductDTO();
result.ID = ID;
result.Name = txtName.Text;
result.IvenNum = Int32.Parse(lblAmount.Content.ToString());
result.InputPrice = Int32.Parse(txtInputPrice.Text);
result.OutputPrice = Int32.Parse(txtOutputPrice.Text);
bus.UpdateProduct(result);
this.Close();
}
// private Button button;
/* public Button Button
* {
* get {
* return (Button)FormView1.FindControl("Button1");
* }
*
* }
*/
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string masp = Request.QueryString["masp"];
if (masp == null)
{
masp = "VL001";
}
ma = masp;
SAN_PHAM_DTO sp = ProductBUS.GetProductInfor(masp);
List <SAN_PHAM_DTO> list = new List <SAN_PHAM_DTO>();
list.Add(sp);
FormView1.DataSource = list;
FormView1.DataBind();
DataList1.DataSource = ProductBUS.GetProductsSameType(sp.MaLoaiSanPham, sp.MaSanPham);
DataList1.DataBind();
/* GridView1.DataSource = list;
* GridView1.DataBind();*/
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
Product product = new Product()
{
id = Int32.Parse(txtId.Text),
name = txtName.Text.ToString(),
cateid = Int32.Parse(txtCateId.Text),
price = Int32.Parse(txtPrice.Text),
description = txtDesc.Text.ToString(),
imagelink = txtImageLink.Text.ToString()
};
if (ProductBUS.Insert(product))
{
MessageBox.Show("Success !");
}
else
{
MessageBox.Show("F**k You !");
}
dataGridView1.DataSource = ProductBUS.getAllProducts();
this.clearText();
}
public Form1()
{
InitializeComponent();
dataGridView1.DataSource = ProductBUS.getAllProducts();
}
public CreateProductForm()
{
_productBUS = new ProductBUS();
InitializeComponent();
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
LoadProductListByTypeProductID(ProductBUS.GeProductByName(txtTuKhoa.Text));
}
// Load datbase to view without change in category and brand
private void onLoad()
{
productTBBindingSource.DataSource = ProductBUS.getAll();
productBindingSource.DataSource = new Product();
dgvProduct.ClearSelection();
}
public ProductListForm()
{
_productBUS = new ProductBUS();
InitializeComponent();
}
protected void txtProductID_TextChanged(object sender, EventArgs e)
{
int ProductID = 0;
if (int.TryParse(txtProductID.Text, out ProductID) != false)
{
ProductID = int.Parse(txtProductID.Text);
prBUS = new ProductBUS();
ConnectionData.OpenMyConnection();
}
else
{
Visible(false);
pnInfo.Visible = true;
lblInfo.Text = "Bạn phải nhập mã sản phẩm là số !";
return;
}
DataTable product = prBUS.GetByID(ProductID);
if (product.Rows.Count > 0)
{
pnInfo.Visible = false;
txtProductName.Text = product.Rows[0]["Title"].ToString();
txtUnitPrice.Text = product.Rows[0]["UnitPrice"].ToString();
txtQuantity.Text = "1";
float total = int.Parse(txtQuantity.Text) * float.Parse(this.txtUnitPrice.Text);
this.txtTotal.Text = total.ToString();
}
else
{
Visible(false);
pnInfo.Visible = true;
lblInfo.Text = "Không tồn tại mã sản phẩm này !";
txtProductName.Text = "";
txtUnitPrice.Text = "";
}
ConnectionData.CloseMyConnection();
}
private void LoadFinancePieChartData(DateTime DayFrom, DateTime DayTo)
{
//Luu id san pham va so luong san pham do ban trong hom nay
List <KeyValue> listKey = new List <KeyValue>();
ExportBUS bus = new ExportBUS();
List <ExportDTO> list = bus.LoadAllExport(); //luu danh sach hoa don
ProductBUS productBUS = new ProductBUS();
for (int i = 0; i < list.Count(); i++)
{
//Kiem tra co nam trong pham vi bao cao hay khong
DateTime soldDay = DateTime.Parse(list[i].DateOutput);
if (soldDay < DayFrom || soldDay > DayTo)
{
continue;
}
bool check = false;
for (int j = 0; j < listKey.Count(); j++)
{
//Xem ton tai trong list hay chua
if (listKey[j].key == list[i].Product)
{ //Da ton tai
check = true;
int income; //income of that bill
ProductDTO product = productBUS.LoadOneProduct(list[i].Product);
income = list[i].Total - product.InputPrice * list[i].Amount;
listKey[j].value += income;
break;
}
}
//neu chua ton tai thi them vao
if (check == false)
{
int income; //income of that bill
ProductDTO product = productBUS.LoadOneProduct(list[i].Product);
income = list[i].Total - product.InputPrice * list[i].Amount;
listKey.Add(new KeyValue()
{
key = list[i].Product, value = income
});
}
}
var listStatistic = new List <KeyValuePair <string, int> >();
for (int i = 0; i < listKey.Count(); i++)
{
ProductDTO product = productBUS.LoadOneProduct(listKey[i].key);
listStatistic.Add(new KeyValuePair <string, int>(product.Name, listKey[i].value));
}
((PieSeries)mcChart.Series[0]).ItemsSource = listStatistic;
}
protected void Page_Load(object sender, EventArgs e)
{
int isLogIn;
int.TryParse(Session["IsLogin"].ToString(), out isLogIn);
if (isLogIn == 1)
{
string typeUser = Session["LoaiUser"].ToString();
if (typeUser == "Manager")
{
#region hiển thị thông tin sản phẩm
if (!IsPostBack)
{
//lấy mã sản phẩm
string masp = Request.QueryString["masp"];
if (masp != "")
{
SAN_PHAM_DTO sp = ProductBUS.LayThongTinSanPhamTheoMaSP(masp);
lbMaSP.Text = sp.MaSanPham;
//xử lý mã loại sp
//lbMaLSP.Text=sp.MaLoaiSanPham.ToString();
LOAISP_DTO lsp = ProductTypeBUS.LayLoaiSanPhamTheoMaLoaiSP(sp.MaLoaiSanPham);
lbMaLSP.Text = lsp.TenLoaiSanPham;
lbTenSP.Text = sp.TenSanPham;
txtareMota.Value = sp.MoTaSanPham;
//xử lý hình ảnh
ImageSP.ImageUrl = sp.HinhAnh;
txtChatLuong.Text = sp.ChatLuong;
txtGiaBan.Text = sp.Gia.ToString();
txtSoLuong.Text = sp.SoLuong.ToString();
txtDonVi.Text = sp.DonViTinh;
lbSoLuongConLai.Text = sp.SoLuongConLai.ToString();
lbNgayDangSP.Text = sp.NgayDangSanPham.ToString("dd/MM/yyyy");
lbNgaySuaDoi.Text = sp.NgaySuaDoi.ToString("dd/MM/yyyy");
//xử lý tình trạng
radiobtnTinhTrang.SelectedValue = sp.TinhTrangSanPham;
if (radiobtnTinhTrang.SelectedValue == "0")
{
radiobtnTinhTrang.Items[0].Enabled = true;
}
else
{
radiobtnTinhTrang.Items[1].Enabled = true;
}
//không hiển thị ngày xóa
txtSoNguoiMua.Text = sp.SoNguoiMua.ToString();
}
}
#endregion
}
else
{
Response.Redirect("../Shared/Default.aspx");
}
}
else
{
Response.Redirect("../Shared/Default.aspx");
}
}
protected void btnPayment_Click(object sender, EventArgs e)
{
string ma = rdvc.SelectedValue;
string[] arr = ma.Split(new char[] { ',' });
int madv = 0;
int.TryParse(arr[0], out madv);
int type = 0;
int.TryParse(arr[1], out type);
string bank = rdbank.SelectedValue;
string[] bankarr = bank.Split(new char[] { '+' });
string bankid = bankarr[0];
string stk = bankarr[1];
/* tao don hang , va xoa gio hang */
if (Session["Cart"] != null)
{
List <GioHang> carts = (List <GioHang>)Session["Cart"];
if (carts.Count > 0)
{
DON_HANG_DTO dh = new DON_HANG_DTO();
dh.DiaChiNhan = txtAddress.Text;
dh.DonViTienTe = carts[0].TienTe;
dh.NgayGiao = DateTime.Now;
dh.UserName = Session["User"].ToString();
dh.TongTien = 0;
foreach (GioHang cart in carts)
{
dh.TongTien += (cart.DonGia * cart.SoLuong);
}
int madh = 0;
madh = DonHangBUS.InsetOrder(dh);
dh.ChiTiet = new List <CHI_TIET_DON_HANG_DTO>();
foreach (GioHang cart in carts)
{
CHI_TIET_DON_HANG_DTO ct = new CHI_TIET_DON_HANG_DTO();
ct.donGia = cart.DonGia;
ct.donViTinh = cart.DonViTinh;
ct.maDonHang = madh;
ct.maSanPham = cart.MaSanPham;
ct.soLuong = cart.SoLuong;
try
{
DonHangBUS.InsertCTOrder(ct);
}
catch (Exception ex)
{
continue;
}
}
/* thanh toan */
SERVICE_BANK_DTO svbank = ServiceBankBUS.LayServiceBankTheoMaBank(bankid);
NganHang.KhachHangWS proxy1 = new BIZ.NganHang.KhachHangWS();
string sid = proxy1.Authenticate(svbank.UserName, svbank.PassWord);
int result = proxy1.TransferMoney(sid, txtId.Text, bankid, svbank.Stk, svbank.MaBank, dh.TongTien, "VND");
if (result == 1)
{
/* dang ky van chuyen */
SERVICE_TRANS_DTO svtran = ServiceTransBUS.GetServiceTransInfor(madv);
VanChuyen.FedexWebService1 proxy2 = new BIZ.VanChuyen.FedexWebService1();
sid = proxy2.Authenticate(svtran.UserName, svtran.PassWord);
string url = proxy2.TransportGoods(sid, madh.ToString(), carts.Count, DateTime.Now.AddDays(1), txtAddress.Text, type, svtran.BizAddress);
if (url.IndexOf(".aspx?") >= 0 || url.IndexOf("http://") >= 0 || url.IndexOf("https://") >= 0)
{
PACKAGEINFO_DTO pac = new PACKAGEINFO_DTO();
pac.URL = url;
pac.MaServiceTrans = svtran.MaDV;
pac.PackageInfo = madh.ToString();
try
{
DonHangBUS.InsertPackage(pac, madh);
foreach (GioHang cart in carts)
{
//CHI_TIET_DON_HANG_DTO ct = new CHI_TIET_DON_HANG_DTO();
try
{
ProductBUS.UpdateSLProduct(cart.MaSanPham, cart.SoLuong);
}
catch (Exception ex)
{
continue;
}
}
Session["Cart"] = null;
lbresult.ForeColor = Color.Green;
lbresult.Text = "Quá trình mua đã thành công";
}
catch (Exception ex)
{
throw ex;
}
}
else
{
lbresult.ForeColor = Color.Red;
lbresult.Text = "Đã thanh toán nhưng đặt vận chuyển thất bại";
}
}
else
{
switch (result)
{
case 2:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Tài khoản chuyển không đủ tiền";
break;
case 3:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Tài khoản chuyển không tồn tại";
break;
case 4:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Tài khoản nhận không tồn tại";
break;
case 5:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Mã ngân hàng chuyển tiền/Mã ngân hàng nhận tiền không tồn tại ";
break;
case 6:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Lỗi khác";
break;
}
}
}
}
}
public Page <SanPham> Get(int id, int page = 1)
{
return(ProductBUS.ListProductType(page, 4, id));
}
// GET: Admin/Product
public ActionResult Index()
{
var listProduct = ProductBUS.List();
return(View(listProduct));
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool status = false;
InitBus();
string err = ValidateInput();
//Thêm khách hàng
if (err == "")
{
try
{
if (ctBUS.GetByEmail(GetCustomerDTO().Email).Rows.Count > 0)
{
CustomerID = int.Parse(ctBUS.GetByEmail(GetCustomerDTO().Email).Rows[0]["Id"].ToString());
ctBUS.tblCustomer_Update(GetCustomerDTO());
}
else
{
CustomerID = ctBUS.tblCustomer_insert(GetCustomerDTO());
}
int GroupID = int.Parse(this.drlGroupMail.SelectedValue);
DetailGroupDTO dgDTO = new DetailGroupDTO() { CustomerID = CustomerID, GroupID = GroupID };
//Thêm vào nhóm mail
if (dgBUS.GetByID(GroupID, CustomerID).Rows.Count == 0)
{
dgBUS.tblDetailGroup_insert(dgDTO);
}
//Thêm vào hóa đơn
if (oBUS.tblOrder_GetByID(GetOrderDTO().OrderID).Rows.Count > 0 || hdfUpdate.Value!="")
{
status = GetOrderDTO().Status;
oBUS.tblOrder_updateStatus(GetOrderDTO().OrderID, status);
}
else
{
oBUS.tblOrder_insert(GetOrderDTO());
}
// Thêm vào chi tiết hóa đơn
DataTable tblProduct = (DataTable)Session["orderList"];
if (tblProduct.Rows.Count > 0)
{
OrderDatailDTO odDTO = new OrderDatailDTO();
for (int i = 0; i < tblProduct.Rows.Count; i++)
{
//Thêm từng sản phẩm vào chi tiết đơn hàng
odDTO.ProductID = int.Parse(tblProduct.Rows[i]["ProductID"].ToString());
odDTO.OrderID = txtOrderID.Text;
odDTO.ProductName = tblProduct.Rows[i]["ProductName"].ToString();
odDTO.DeliveryCode = tblProduct.Rows[i]["DeliveryCode"].ToString();
odDTO.UnitPrice = float.Parse(tblProduct.Rows[i]["UnitPrice"].ToString());
odDTO.Quantity = int.Parse(tblProduct.Rows[i]["Quantity"].ToString());
odDTO.Total = odDTO.Quantity * odDTO.UnitPrice;
odDTO.Note = tblProduct.Rows[i]["Note"].ToString();
odDTO.Size = "M";
int CateGoryID;
if (odBUS.tblOrderDetail_GetByID(txtOrderID.Text, odDTO.ProductID).Rows.Count > 0)
{
odBUS.tblOrderDetail_update(odDTO);
}
else
{
odBUS.tblOrderDetail_insert(odDTO);
}
if (status == true)
{
prBUS = new ProductBUS();
//Lấy nhóm của sản phẩm
CateGoryID = int.Parse(prBUS.GetByID(odDTO.ProductID).Rows[0]["Category"].ToString());
countBUS = new CountBuyBUS();
if (countBUS.GetByID(CustomerID, CateGoryID).Rows.Count > 0)
{
//Cập nhật số lần mua của khách hàng này theo nhóm sản phẩm
countBUS.tblCountBuy_UpdateCountBuy(CustomerID, CateGoryID);
}
else
{
//Thêm vào đếm lần mua theo nhóm
countBUS.tblCountBuy_insert(CustomerID, CateGoryID, 1);
}
}
}
//Cập nhật số lần mua cho khách hàng
if (status == true)
{
ctBUS = new CustomerBUS();
ctBUS.tblCustomer_UpdateCountBuy(CustomerID);
}
//Load lại thông tin khách hàng
Visible(false);
pnSuccess.Visible = true;
lblSuccess.Text = "Cập nhật thành công một đơn hàng";
LoadDefautlValue();
Session["orderList"] = null;
//Tạo mã hóa đơn tự động
AutoCreateID();
}
}
catch (Exception ex)
{
Visible(false);
pnError.Visible = true;
lblError.Text = "Lỗi xảy ra trong quá trình nhập:" + ex.Message;
}
}
else
{
Visible(false);
pnError.Visible = true;
lblError.Text = err;
}
}
