public List <DonDatHangDTO> Laydsdondathang()
{
List <DonDatHangDTO> ls = new List <DonDatHangDTO>();
string truyvan = "SELECT * FROM DON_DAT_HANG";
SqlConnection con = DataProvider.TaoKetNoi();
SqlDataReader sr = DataProvider.TruyVanDuLieu(truyvan, con);
while (sr.Read())
{
DonDatHangDTO dto = new DonDatHangDTO();
dto.MaDonDH = sr["MaDonDH"].ToString();
dto.NgayDat = DateTime.Parse(sr["NgayDat"].ToString());
dto.NgayGiao = DateTime.Parse(sr["NgayGiao"].ToString());
dto.DiaChiGiao = sr["DiaChiGiao"].ToString();
dto.SoDienThoai = int.Parse(sr["SoDienThoai"].ToString());
dto.TongTien = decimal.Parse(sr["TongTien"].ToString());
dto.KhachHangDat = sr["KhachHangDat"].ToString();
dto.NVLap = sr["NVLap"].ToString();
dto.TinhTrang = int.Parse(sr["TinhTrang"].ToString());
ls.Add(dto);
}
con.Close();
sr.Close();
return(ls);
}
private void btnDatHang_Click(object sender, EventArgs e)
{
if (lvwChiTietDDh.Items.Count == 0)
{
MessageBox.Show("Bạn chưa thêm hàng hóa vào đơn đặt hàng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
DonDatHangDTO ddhDTO = new DonDatHangDTO();
ddhDTO.Manvlap = tkGlobal.Manv;
ddhDTO.Mancc = Convert.ToInt32(cboNhaCungCap.SelectedValue);
ddhDTO.Ngaygiao = dtpNgayGiao.Value;
DonDatHangBUS ddhBUS = new DonDatHangBUS();
int maDDH;
if (ddhBUS.ThemDDH(ddhDTO, out maDDH))
{
foreach (ListViewItem item in lvwChiTietDDh.Items)
{
ChiTietDonDatHangBUS ctBUS = new ChiTietDonDatHangBUS();
ChiTietDonDatHangDTO ctDTO = new ChiTietDonDatHangDTO();
ctDTO.Maddh = maDDH;
ctDTO.Mahh = Convert.ToInt32(item.SubItems[2].Text);
ctDTO.Sl = Convert.ToInt32(item.SubItems[1].Text);
ctBUS.ThemChiTietDDH(ctDTO);
}
MessageBox.Show("Đặt hàng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsDDH();
}
else
{
MessageBox.Show("Đặt hàng thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// DonDatHangBUS ddhbus = new DonDatHangBUS();
// List<HangHoaDTO> listhh = new List<HangHoaDTO>();
//foreach(ListViewItem item in lvwChiTietDDh.Items)
//{
// HangHoaDTO hhtam = new HangHoaDTO();
// hhtam.Tenhh = item.Text;
// hhtam.Slton = Convert.ToInt32(item.SubItems[1].Text);
// hhtam.Mahh = Convert.ToInt32(item.SubItems[2].Text);
// listhh.Add(hhtam);
//}
//if (ddhbus.ThemDonDatHangTest(listhh, dtpNgayGiao.Value, tkGlobal.Manv, Convert.ToInt32(cboNhaCungCap.SelectedValue.ToString())))
//{
// {
// MessageBox.Show("thành công", "thông báo");
// LoadDanhSachDDH();
// }
//}
//else
// MessageBox.Show("thất bại", "thông báo");
}
public HttpResponseMessage GetorderByID([FromUri] int id)
{
UserDTO user = new UserDTO();
List <KhachHang> person = db.KhachHangs.Where(x => x.MaThanhVien == id).ToList();
List <DonDatHangDTO> listsp = new List <DonDatHangDTO>();
foreach (var cart in person)
{
List <DonDatHang> DDH = db.DonDatHangs.Where(x => x.MaKH == cart.MaKH && x.TrangThai == true).ToList();
if (DDH == null)
{
user.DDHDTO = null;
}
else
{
foreach (var item in DDH)
{
DonDatHangDTO sp = new DonDatHangDTO();
sp.MaDDH = item.MaDDH;
sp.NgayDat = item.NgayDat;
sp.NgayGiao = item.NgayGiao;
sp.DaThanhToan = item.DaThanhToan;
sp.TinhTrangGiaoHang = item.TinhTrangGiaoHang;
List <ChiTietDonDatHang> ctddh = db.ChiTietDonDatHangs.Where(x => x.MaDDH == sp.MaDDH).ToList();
if (ctddh == null)
{
sp.chitietDDH = null;
}
else
{
List <ChiTietDonDatHangDTO> listctddhDTO = new List <ChiTietDonDatHangDTO>();
foreach (var item2 in ctddh)
{
ChiTietDonDatHangDTO ctddhDTO = new ChiTietDonDatHangDTO();
ctddhDTO.MaChiTietDDH = item2.MaChiTietDDH;
ctddhDTO.MaDDH = item2.MaDDH;
ctddhDTO.MaSP = item2.MaSP;
ctddhDTO.TenSP = item2.TenSP;
ctddhDTO.HinhAnh = item2.SanPham.HinhAnh;
ctddhDTO.SoLuong = item2.SoLuong;
ctddhDTO.DonGia = item2.DonGia;
ctddhDTO.ThanhTien = item2.ThanhTien;
listctddhDTO.Add(ctddhDTO);
}
sp.chitietDDH = listctddhDTO;
}
listsp.Add(sp);
}
}
}
user.DDHDTO = listsp;
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
public bool XoaDDH(DonDatHangDTO DTO)
{
string DELETE = "UPDATE DON_DAT_HANG SET TINHTRANG=0 WHERE MADONDH = @MaDonDH";
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@MaDonDH", DTO.MaDonDH);
SqlConnection con = DataProvider.TaoKetNoi();
int kq = DataProvider.ThucThiCauLenh(DELETE, p, con);
con.Close();
return(kq > 0);
}
public JsonResult GetOrderDetail(string id)
{
DonDatHangDTO order = donDatHangBL.GetDonDatHangById(id);
KhachHangDTO customer = khachHangBL.GetCustomerByOrderId(id);
List <OrderDTO> listOrderDetail = chiTietDonDatHangBL.GetListOrderDetailByOrderId(id);
return(Json(new
{
order = order,
customer = customer,
orderDetail = listOrderDetail,
status = true
}));
}
private void btnIn_Click(object sender, EventArgs e)
{
if (DonDatHangBUS.KiemTraChiTietDonDatHang(dgvDanhSach.RowCount) == "")
{
// Thêm đơn đặt hàng.
DonDatHangDTO DDH = new DonDatHangDTO();
DDH.MaDonDatHang = txtSoPĐ.Text;
DDH.NgayLap = dtkNgayDat.Value;
DDH.TongTien = Tien;
if (DonDatHangBUS.ThemPD(DDH) == true)
{
btnLapPhieuMoi.Enabled = true;
btnThemSP.Enabled = false;
cboNCC.Enabled = true;
// Thêm chi tiết đơn đặt hàng.
for (int k = 0; k < dgvDanhSach.Rows.Count; k++)
{
ChiTietDonDatHangDTO PN = new ChiTietDonDatHangDTO();
PN.MaDonDatHang = txtSoPĐ.Text;
PN.MaSanPham = dgvDanhSach.Rows[k].Cells[0].Value.ToString();
PN.SoLuong = int.Parse(dgvDanhSach.Rows[k].Cells[3].Value.ToString());
if (DonDatHangBUS.ThemCTPD(PN) == true)
{
btnIn.Enabled = false;
}
else
{
MessageBox.Show("Thêm chi tiết phiếu đặt hàng thất bại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Xuất ra cystal report.
frmXuatDonDatHang frm = new frmXuatDonDatHang(txtSoPĐ.Text);
this.Hide();
frm.ShowDialog();
this.Show();
}
else
{
MessageBox.Show("Thêm phiếu đặt hàng thất bại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(string.Format("{0}", DonDatHangBUS.KiemTraChiTietDonDatHang(dgvDanhSach.RowCount)), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool ThemDDH(DonDatHangDTO ddh, out int maDDH)
{
maDDH = 0;
try
{
DON_DAT_HANG ddhtam = new DON_DAT_HANG();
ddhtam.MANVLAP = ddh.Manvlap;
ddhtam.MANCC = ddh.Mancc;
ddhtam.NGAYLAP = DateTime.Now;
ddhtam.NGAYGIAO = ddh.Ngaygiao;
db.DON_DAT_HANG.Add(ddhtam);
db.SaveChanges();
maDDH = ddhtam.MADDH;
return(true);
}
catch (Exception r)
{
return(false);
}
}
public bool SuaDDH(DonDatHangDTO DTO)
{
string UPDATE = "UPDATE DON_DAT_HANG SET NGAYDAT=@NgayDat,NGAYGIAO=@NgayGiao,DIACHIGIAO=@DiaChiGiao,SODIENTHOAI=@SDT,TONGTIEN=@TongTien,KHACHHANGDAT=@MaKH,NVLAP=@NVLap,TINHTRANG=@TinhTrang WHERE MADONDH=@MaDonDH";
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@MaDonDH", DTO.MaDonDH);
p[1] = new SqlParameter("@NgayDat", DTO.NgayDat);
p[2] = new SqlParameter("@NgayGiao", DTO.NgayGiao);
p[3] = new SqlParameter("@DiaChiGiao", DTO.DiaChiGiao);
p[4] = new SqlParameter("@SDT", DTO.SoDienThoai);
p[5] = new SqlParameter("@TongTien", DTO.TongTien);
p[6] = new SqlParameter("@MaKH", DTO.KhachHangDat);
p[7] = new SqlParameter("@NVLap", DTO.NVLap);
p[8] = new SqlParameter("@TinhTrang", DTO.TinhTrang);
SqlConnection con = DataProvider.TaoKetNoi();
int kq = DataProvider.ThucThiCauLenh(UPDATE, p, con);
con.Close();
return(kq > 0);
}
public bool ThemDDH(DonDatHangDTO DTO)
{
string INSERT = "INSERT INTO DON_DAT_HANG VALUES(@MADONNDH,@NgayDAT,@NgayGiao,@DiaChi,@SDT,@TongTien,@MaKH,@NVLapHD,@TinhTrang)";
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@MADONNDH", DTO.MaDonDH);
p[1] = new SqlParameter("@NgayDAT", DTO.NgayDat);
p[2] = new SqlParameter("@NgayGiao", DTO.NgayGiao);
p[3] = new SqlParameter("@DiaChi", DTO.DiaChiGiao);
p[4] = new SqlParameter("@SDT", DTO.SoDienThoai);
p[5] = new SqlParameter("@TongTien", DTO.TongTien);
p[6] = new SqlParameter("@MaKH", DTO.KhachHangDat);
p[7] = new SqlParameter("@NVLapHD", DTO.NVLap);
p[8] = new SqlParameter("@TinhTrang", 1);
SqlConnection con = DataProvider.TaoKetNoi();
int kq = DataProvider.ThucThiCauLenh(INSERT, p, con);
con.Close();
return(kq > 0);
}
public DonDatHangDTO ConvertDonDatHangToDonDatHangDTO(DonDatHang item)
{
DonDatHangDTO dto = new DonDatHangDTO();
dto.Id = item.Id;
dto.TenKh = khachHangBL.GetCustomerById(item.IdKh).TenKh;
dto.NgayDat = item.NgayDat.Value.ToShortDateString();
dto.TrangThai = db.TrangThaiGiaoHang.Where(t => t.Id == item.TrangThai).FirstOrDefault().TenTrangThai;
dto.TongTien = GetPriceForOrder(item.Id);
dto.IdTrangThai = (int)item.TrangThai;
dto.IsConfirm = item.IsConfirm;
if (item.NgayGiao == null)
{
dto.NgayGiao = "";
}
else
{
dto.NgayGiao = String.Format("{0:yyyy-MM-dd}", item.NgayGiao.Value);
}
return(dto);
}
public static bool ThemPD(DonDatHangDTO DDH)
{
try
{
SqlConnection con = DataProvider.Connection();
SqlCommand cmd = new SqlCommand("sp_ThemPD", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@maddh", SqlDbType.VarChar);
cmd.Parameters.Add("@ngaydat", SqlDbType.Date);
cmd.Parameters.Add("@tongtien", SqlDbType.Int);
cmd.Parameters["@maddh"].Value = DDH.MaDonDatHang;
cmd.Parameters["@ngaydat"].Value = DDH.NgayLap;
cmd.Parameters["@tongtien"].Value = DDH.TongTien;
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool XoaDDH(DonDatHangDTO DTO)
{
DonDatHangDAO dao = new DonDatHangDAO();
return(dao.XoaDDH(DTO));
}
public HttpResponseMessage Login([FromBody] LoginDTO login)
{
var entity = db.ThanhViens.SingleOrDefault(x => x.TaiKhoan == login.username);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found"));
}
else if (entity.MatKhau != Models.DAL.MaHoa.MD5Hash(login.password))
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found"));
}
else
{
UserDTO user = new UserDTO();
user.MaThanhVien = entity.MaThanhVien;
user.HoTen = entity.HoTen;
user.DiaChi = entity.DiaChi;
user.Email = entity.Email;
user.SoDienThoai = entity.SoDienThoai;
List <KhachHang> person = db.KhachHangs.Where(x => x.MaThanhVien == user.MaThanhVien).ToList();
List <DonDatHangDTO> listsp = new List <DonDatHangDTO>();
foreach (var cart in person)
{
List <DonDatHang> DDH = db.DonDatHangs.Where(x => x.MaKH == cart.MaKH && x.TrangThai == true).ToList();
if (DDH == null)
{
user.DDHDTO = null;
}
else
{
foreach (var item in DDH)
{
DonDatHangDTO sp = new DonDatHangDTO();
sp.MaDDH = item.MaDDH;
sp.NgayDat = item.NgayDat;
sp.NgayGiao = item.NgayGiao;
sp.DaThanhToan = item.DaThanhToan;
sp.TinhTrangGiaoHang = item.TinhTrangGiaoHang;
List <ChiTietDonDatHang> ctddh = db.ChiTietDonDatHangs.Where(x => x.MaDDH == sp.MaDDH).ToList();
if (ctddh == null)
{
sp.chitietDDH = null;
}
else
{
List <ChiTietDonDatHangDTO> listctddhDTO = new List <ChiTietDonDatHangDTO>();
foreach (var item2 in ctddh)
{
ChiTietDonDatHangDTO ctddhDTO = new ChiTietDonDatHangDTO();
ctddhDTO.MaChiTietDDH = item2.MaChiTietDDH;
ctddhDTO.MaDDH = item2.MaDDH;
ctddhDTO.MaSP = item2.MaSP;
ctddhDTO.TenSP = item2.TenSP;
ctddhDTO.SoLuong = item2.SoLuong;
ctddhDTO.DonGia = item2.DonGia;
ctddhDTO.HinhAnh = item2.SanPham.HinhAnh;
ctddhDTO.ThanhTien = item2.ThanhTien;
listctddhDTO.Add(ctddhDTO);
}
sp.chitietDDH = listctddhDTO;
}
listsp.Add(sp);
}
}
}
user.DDHDTO = listsp;
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
}
public static bool ThemPD(DonDatHangDTO DDH)
{
return(DonDatHangDAO.ThemPD(DDH));
}
public bool SUADDH(DonDatHangDTO DTO)
{
DonDatHangDAO DAO = new DonDatHangDAO();
return(DAO.SuaDDH(DTO));
}
public bool ThemDDH(DonDatHangDTO DTO)
{
DonDatHangDAO Dao = new DonDatHangDAO();
return(Dao.ThemDDH(DTO));
}
public bool ThemDDH(DonDatHangDTO ddh, out int maDDH)
{
return(ddhDAO.ThemDDH(ddh, out maDDH));
}
