protected void btnLuu_Click(object sender, EventArgs e)
{
DTOCongNoBanHang dto = new DTOCongNoBanHang();
dto.MaDH = lbMaDH.Text;
dto.MaKH = int.Parse(lbMaKH.Text);
dto.MaNV = int.Parse(txtMaNV.Text);
dto.NgayTraNo = Convert.ToDateTime(lbNgayTra.Text);
dto.TienTT = int.Parse(txtTienTT.Text);
DAO_Entity dao = new DAO_Entity();
dao.ThemCongNoBH(dto);
DTODonDatHang dtodh = new DTODonDatHang();
dtodh.MaDH = lbMaDH.Text;
int tong = int.Parse(lbTienTra.Text);
int no = int.Parse(txtTienTT.Text);
dtodh.CongNoDH = tong - no;
dao.CapNhatCongNo(dtodh);
if (dtodh.CongNoDH == 0)
{
dao.CapNhatTrangThaisauThanhToan(dtodh);
}
Response.Redirect("~/QLBoPhan_ThanhPham/QuanLyQuanNo_BH/DanhSachCongNo_BH.aspx");
}
protected void btbLuu_Click(object sender, EventArgs e)
{
DTOThanhToan dtocn = new DTOThanhToan();
dtocn.MaDH = txtMaDH.Text;
dtocn.MaNV = int.Parse(txtNhanVien.Text);
dtocn.NgayThanhToan = Convert.ToDateTime(txtNgayThanhToan.Text);
dtocn.Sotien = int.Parse(txtDatCoc.Text);
dtocn.HanTT = Convert.ToDateTime(txtHanTT.Text);
DAO_Entity daokh = new DAO_Entity();
XuLy_TiepNhanDonHang control = new XuLy_TiepNhanDonHang();
control.themdatcoc(dtocn);
DTODonDatHang dtodh = new DTODonDatHang();
dtodh.MaDH = txtMaDH.Text;
int tong = int.Parse(txtTong.Text);
int no = int.Parse(txtDatCoc.Text);
dtodh.CongNoDH = tong - no;
daokh.CapNhatCongNo(dtodh);
Response.Redirect("~/QLBoPhan_TiepXucKH/TaoDonHang.aspx?MaKH=" + int.Parse(txtMaKH.Text));
}
protected void btLuuCt_Click(object sender, EventArgs e)
{
int ma = int.Parse(lbMadh.Text);
DAO_Entity daokh = new DAO_Entity();
DTODonDatHang dtodh = new DTODonDatHang();
DTOChiTietDonHang dtoct = daokh.LayTongTien(ma);
dtodh.TongTien = int.Parse(dtoct.ThanhTien.ToString());
dtodh.CongNoDH = dtodh.TongTien;
daokh.CapNhatTongTien(dtodh);
Response.Redirect("~/QLBoPhan_TiepXucKH/TaoDonHang.aspx?MaKH=" + lbMaKH.Text);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
string maDH = Request.QueryString["MaDH"].ToString();
DAO_Entity daoDH = new DAO_Entity();
DTODonDatHang dtoDH = daoDH.LayDHTheoMa(maDH);
lbMaDH.Text = dtoDH.MaDH.ToString();
lbMaKH.Text = dtoDH.MaKH.ToString();
lbTenKH.Text = dtoDH.TenKH.ToString();
lbTienTra.Text = dtoDH.CongNoDH.ToString();
lbNgayTra.Text = DateTime.Now.ToShortDateString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string madh = Request.QueryString["MaDH"].ToString();
List <DTOChiTietDH> dsCTDH = daoEntities.LayDSChiTietDH(madh);
//XuLy_TiepNhanDonHang control = new XuLy_TiepNhanDonHang();
//control.laychitietdh(madh);
GridView1.DataSource = dsCTDH;
GridView1.DataBind();
int tongtien = 0;
foreach (DTOChiTietDH dtoChiTiet in dsCTDH)
{
tongtien += dtoChiTiet.ThanhTien;
}
lbTongTien.Text = tongtien.ToString();
lbTongSP.Text = dsCTDH.Count.ToString();
}
catch
{
Response.Write("<script>alert('Loi tai du lieu!')</script>");
}
if (IsPostBack == false)
{
string maDH = Request.QueryString["MaDH"].ToString();
DTODonDatHang dtoDH = daoEntities.LayDHTheoMa(maDH);
lbMadh.Text = dtoDH.MaDH.ToString();
lbMaKH.Text = dtoDH.MaKH.ToString();
tenKH.Text = dtoDH.TenKH.ToString();
if (GridView1.Rows.Count != 0 && dtoDH.TongTien != 0)
{
btLuuCt.Visible = false;
}
else
{
//lbTong.Visible = false;
//txtTongtien.Visible = false;
btLuuCt.Visible = true;
}
int sum = GridView1.Rows.Count;
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
dsThanhPhamChon = (List <DTOChiTietDH>)Session["dsThanhPhamChon"];
try
{
string maDH = DateTime.Now.ToString("yyyyMMddHHmmss");
DTODonDatHang dtoDonHang = new DTODonDatHang();
int tongtien = 0;
foreach (DTOChiTietDH row in dsThanhPhamChon)
{
tongtien += row.ThanhTien;
}
dtoDonHang.MaDH = maDH;
dtoDonHang.MaKH = int.Parse(lbMaKH.Text);
dtoDonHang.NgayTaoDH = Convert.ToDateTime(txtNgayTaoDH.Text);
dtoDonHang.NgayGH = Convert.ToDateTime(txtGiao.Text);
dtoDonHang.TongTien = 0;
dtoDonHang.CongNoDH = 0;
dtoDonHang.TongTien = tongtien;
dtoDonHang.CongNoDH = tongtien;
dtoDonHang.TrangThai = "Chưa Xử Lý";
//XuLy_TiepNhanDonHang control = new XuLy_TiepNhanDonHang();
//control.themdh(dtoDonHang);
if (daoEntities.ThemDonHang(dtoDonHang))
{
foreach (DTOChiTietDH dtoCTDH in dsThanhPhamChon)
{
dtoCTDH.MaDH = maDH;
//control.themct(dtoCTDH);
if (daoEntities.ThemChiTietDH(dtoCTDH))
{
Session["dsThanhPhamChon"] = null;
}
}
}
Response.Redirect(Request.RawUrl);
}
catch (Exception)
{
throw;
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
if (Session["dsThanhPhamTra"] != null)
{
dsThanhPhamTra = (List <DTOChiTietDH>)Session["dsThanhPhamTra"];
int dem = 0;
string maDH = lbMaDH.Text;
foreach (DTOChiTietDH dtoCTDH in dsThanhPhamTra)
{
DTOXLSC_HDBH dtoct = new DTOXLSC_HDBH();
dtoct.MaDH = lbMaDH.Text;
dtoct.MaSP = dtoCTDH.dtoSP.MaSP;
dtoct.Soluong = dtoCTDH.SoLuong;
dtoct.ThanhTien = dtoCTDH.ThanhTien;
if (daoEntities.ThemXuLyTraHang(dtoct))
{
DTOChiTietDH dtoChiTietDHTra = new DTOChiTietDH();
DTOChiTietDH dtoChiTietDonHangDat = daoEntities.LayChiTietDonHangTheoMaDHMaSP(maDH, dtoCTDH.dtoSP.MaSP);
dtoChiTietDHTra.MaDH = lbMaDH.Text;
dtoChiTietDHTra.MaSP = dtoCTDH.dtoSP.MaSP;
dtoChiTietDHTra.SoLuong = dtoChiTietDonHangDat.SoLuong - dtoCTDH.SoLuong;
dtoChiTietDHTra.ThanhTien = dtoChiTietDonHangDat.ThanhTien - dtoCTDH.ThanhTien;
if (daoEntities.CapNhatChiTietDH(dtoChiTietDHTra))
{
dem++;
}
}
}
if (dem == dsThanhPhamTra.Count)
{
DTODonDatHang dtoDonHang = daoEntities.LayDHTheoMa(maDH);
int tongTienTra = int.Parse(lbTongTien.Text),
tongTienDaDat = dtoDonHang.TongTien,
congnoCu = dtoDonHang.CongNoDH,
tongTienPhaiTra = 0, congnoConLai = 0;
tongTienPhaiTra = tongTienDaDat - tongTienTra;
congnoConLai = congnoCu - tongTienTra;
daoEntities.CapNhatDonHang(maDH, tongTienPhaiTra, congnoConLai);
}
Response.Redirect(Request.RawUrl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
string maDH = Request.QueryString["MaDH"].ToString();
Xuly_PhanboThanhPham control = new Xuly_PhanboThanhPham();
control.LayDonHangTheoMa(maDH);
DAO_Entity daoDH = new DAO_Entity();
DTODonDatHang dtoDH = daoDH.LayDHTheoMa(maDH);
lbMaDH.Text = dtoDH.MaDH.ToString();
lbKH.Text = dtoDH.MaKH.ToString();
}
try
{
string madh = Request.QueryString["MaDH"].ToString();
Xuly_PhanboThanhPham control = new Xuly_PhanboThanhPham();
control.LayCTDH(madh);
DAO_Entity daokh = new DAO_Entity();
List <DTOChiTietDH> dtoct = daokh.LayDSChiTietDH(madh);
GridView1.DataSource = dtoct;
GridView1.DataBind();
List <DTOXuLyPhieuGiao> dto = daokh.LayDSPhieuGiao(madh);
GridView3.DataSource = dto;
GridView3.DataBind();
control.LayDSkhosp();
List <DTOKhoSP> dtok = daokh.LayDSKhoSP();
GridView2.DataSource = dtok;
GridView2.DataBind();
}
catch
{
Response.Write("<script>alert('Loi tai du lieu!')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (IsPostBack == false)
{
if (Request.QueryString["MaDH"] != null)
{
string maDH = Request.QueryString["MaDH"].ToString();
DTODonDatHang dtoDH = daoEntities.LayDonHangTraHang(maDH);
lbMaDH.Text = dtoDH.MaDH.ToString();
lbMaKH.Text = dtoDH.MaKH.ToString();
lbTenKH.Text = dtoDH.TenKH.ToString();
List <DTOChiTietDH> dsChiTietDonHang = daoEntities.LayDSChiTietDH(maDH);
gridChiTietDonHang.DataSource = dsChiTietDonHang;
gridChiTietDonHang.DataBind();
gridDSCanTra.DataSource = dsChiTietDonHang;
gridDSCanTra.DataBind();
int tongtien = 0;
foreach (DTOChiTietDH dtoCT in dsChiTietDonHang)
{
tongtien += dtoCT.ThanhTien;
}
lbTongTienDaDat.Text = tongtien.ToString();
}
}
}
catch
{
Response.Write("<script>alert('Loi tai du lieu!')</script>");
}
}
public void themdh(DTODonDatHang dtodh)
{
DAO_Entity dao = new DAO_Entity();
dao.ThemDonHang(dtodh);
}
