private void txtMaHang_TextChanged(object sender, EventArgs e)
{
if (kiemTraTonTai(txtMaHang.Text) != null)
{
Hang h = kiemTraTonTai(txtMaHang.Text);
txtTenHang.Text = h.TenHang;
txtDonViTinh.Text = h.DonViTinh;
txtDonGia.Text = h.DonGia.ToString();
cboLoai.DataSource = bulLoaiHang.layDanhSachMaLoaiHang(txtMaHang.Text);
cboLoai.DisplayMember = "TenLoai";
cboLoai.ValueMember = "MaLoai";
int vt = -1;
for (int i = 0; i < bulLoaiHang.layDanhSachMaLoaiHang(txtMaHang.Text).Count; i++)
{
if (bulLoaiHang.layDanhSachMaLoaiHang(txtMaHang.Text)[i].MaLoai.Contains(h.MaLoai))
{
vt = i;
break;
}
}
cboLoai.SelectedIndex = vt;
txtSoLuongCo.Text = h.SoLuongCo.ToString();
cboNCC.DataSource = bulNhaCungCap.layDanhSachMaNCC(txtMaHang.Text);
cboNCC.DisplayMember = "TenNhaCungCap";
cboNCC.ValueMember = "MaNhaCungCap";
for (int i = 0; i < bulNhaCungCap.layDanhSachMaNCC(txtMaHang.Text).Count; i++)
{
if (bulNhaCungCap.layDanhSachMaNCC(txtMaHang.Text)[i].MaNhaCungCap.Contains(h.MaNhaCungCap))
{
vt = i;
break;
}
}
cboNCC.SelectedIndex = vt;
txtTenHang.Enabled = false;
txtDonViTinh.Enabled = false;
txtDonGia.Enabled = false;
cboLoai.Enabled = false;
txtSoLuongCo.Enabled = false;
cboNCC.Enabled = false;
btnXoaHang.Enabled = true;
}
else
{
Hang h = kiemTraTonTai(txtMaHang.Text);
txtTenHang.Text = "";
txtDonViTinh.Text = "";
txtDonGia.Text = "";
//cboLoai.SelectedValue = "";
txtSoLuongCo.Text = "";
//cboNCC.SelectedValue = "";
btnXoaHang.Enabled = false;
}
}
public ActionResult Delete(int id, Hang hangs)
{
hangs = (from s in data.Hangs
where s.MaH == id
select s).FirstOrDefault();
SanPham sanpham = (from s in data.SanPhams where s.MaH == id select s).FirstOrDefault();
if (sanpham != null)
{
return(HttpNotFound());
}
else
{
try
{
data.Hangs.DeleteOnSubmit(hangs);
data.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
}
public JsonResult ThemHangJson(string tenHang, string moTa, int id)
{
//Khai báo 1 đối tượng
Hang objHang = new Hang();
//Gán giá trị
objHang.TenHang = tenHang;
objHang.MoTa = moTa;
if (id > 0)//TH sửa
{
objHang.Id = id;
//Lấy đối tượng cũ
Hang objHangOld = DataProvider.ShopEntities.Hangs.Where(p => p.Id == id).First();
DataProvider.ShopEntities.Entry(objHangOld).CurrentValues.SetValues(objHang);
}
else
{
//Thực hiện thêm và lưu sự thay đổi
DataProvider.ShopEntities.Hangs.Add(objHang);
}
DataProvider.ShopEntities.SaveChanges();
return(Json(objHang, JsonRequestBehavior.AllowGet));
}
void edit()
{
if (tb_mahh.Text == "" || tb_tenhh.Text == "")
{
MessageBox.Show("Mã hh và tên hh không đc để trống", "Cảnh báo");
}
else
{
try
{
string id = tb_mahh.Text;
Hang sv = db.Hangs.Find(id);
sv.Ten_hh = tb_tenhh.Text;
sv.Don_vi = tb_donvi.Text;
db.SaveChanges();
MessageBox.Show("Sửa thành công", "Message");
tb_mahh.Text = "";
tb_tenhh.Text = "";
tb_donvi.Text = "";
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString(), "ERROR");
}
}
}
public ActionResult Orders()
{
KhachHang skhachHang = Session["khachHang"] as KhachHang;
if (skhachHang == null || db.KhachHangs.Where(d => d.MaKH == skhachHang.MaKH).FirstOrDefault() == null)
{
return(RedirectToAction("Index", "Login"));
}
DonHangDat donHangDat = db.DonHangDats.Where(d =>
d.MaKH == skhachHang.MaKH &&
d.TrangThai == "Đang đặt" &&
d.DaXoa == false
).Include(d => d.HangDonHangDats).FirstOrDefault();
if (donHangDat == null || donHangDat.HangDonHangDats.Count() == 0)
{
return(RedirectToAction("Index", "Home", new { ThongBao = "Đơn hàng trống" }));
}
foreach (HangDonHangDat hangDonHangDat in donHangDat.HangDonHangDats)
{
Hang hang = db.Hangs.Where(d => d.MaH == hangDonHangDat.MaH).Include(d => d.MauHang).FirstOrDefault();
hangDonHangDat.Hang = hang;
}
ViewBag.CartBackStore = true;
return(View("Order", donHangDat));
}
void add()
{
if (tb_mahh.Text == "" || tb_tenhh.Text == "")
{
MessageBox.Show("Mã hh và tên hh không đc để trống", "Cảnh báo");
}
else
{
try
{
Hang kho = new Hang()
{
Ma_hh = tb_mahh.Text, Ten_hh = tb_tenhh.Text, Don_vi = tb_donvi.Text
};
db.Hangs.Add(kho);
db.SaveChanges();
MessageBox.Show("Thêm mới thành công", "Message");
tb_mahh.Text = "";
tb_tenhh.Text = "";
tb_donvi.Text = "";
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString(), "ERROR");
}
}
}
public ActionResult VerifyDocument(string MaDHN)
{
NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung;
if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null)
{
return(RedirectToAction("Index", "Login"));
}
DonHangNhap donHangNhap = db.DonHangNhaps.Where(d => d.MaDHN == MaDHN && d.DaDuyet == false && d.DaXoa == false).Include(d => d.HangDonHangNhaps).FirstOrDefault();
if (donHangNhap == null)
{
return(RedirectToAction("Index"));
}
if (donHangNhap.HangDonHangNhaps.Count() == 0)
{
return(RedirectToAction("EditDocument", new { MaDHN = MaDHN, Loi = "Đơn hàng rỗng" }));
}
foreach (HangDonHangNhap hangDonHangNhap in donHangNhap.HangDonHangNhaps)
{
Hang hang = db.Hangs.Where(d => d.MaH == hangDonHangNhap.MaH).Include(d => d.MauHang).FirstOrDefault();
hang.DaNhap = true;
hang.SoLuong += hangDonHangNhap.SoLuong;
}
donHangNhap.DaDuyet = true;
db.SaveChanges();
return(RedirectToAction("Index", new { XoaThanhCong = "Duyệt đơn hàng " + MaDHN + " thành công!" }));
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
ToCat toCat = ((ToCat)cbbToCat.SelectedItem);
Hang hang = ((Hang)cbbSanPham.SelectedItem);
int IdHang = 0;
int.TryParse(hang.MaHang, out IdHang);
if (!string.IsNullOrEmpty(txtIdSanLuongCat.Text))
{
int Id = 0;
int.TryParse(txtIdSanLuongCat.Text, out Id);
int kq = -1;
kq = sanLuongCatDAO.XoaOBJ(Id);
if (kq != -1)
{
MessageBox.Show("Xoá mặt hàng thành công", "Xử lý thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadSanLuongRaDataGridView(toCat.IdToCat, IdHang, dtpNgayNhap.Value);
}
}
else
{
MessageBox.Show("Lỗi thao tác: Bạn chưa chọn tổ cắt muốn xoá.", "Lỗi thao tác", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Đã có lỗi xảy ra: " + ex.Message, "Lỗi xử lý", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnThemVaoGioNhapHang_Click(object sender, EventArgs e)
{
int mahang = Convert.ToInt32(dgvDanhSachHang.CurrentRow.Cells[0].Value);
String tenhang = dgvDanhSachHang.CurrentRow.Cells[1].Value.ToString();
int soluong = (int)numSoLuong.Value;
String thongso = dgvDanhSachHang.CurrentRow.Cells["thongso"].Value.ToString();
int gia = Convert.ToInt32(dgvDanhSachHang.CurrentRow.Cells["gia"].Value);
String hinh = dgvDanhSachHang.CurrentRow.Cells["hinh"].Value.ToString();
int baohanh = Convert.ToInt32(dgvDanhSachHang.CurrentRow.Cells["baohanh"].Value);
int madanhmuc = Convert.ToInt32(dgvDanhSachHang.CurrentRow.Cells["madanhmuc"].Value);
String ngaytao = DateTime.Now.ToString("yyyy-MM-dd");
String nhasanxuat = dgvDanhSachHang.CurrentRow.Cells["nhasanxuat"].Value.ToString();
Hang hang = new Hang(mahang, tenhang, thongso, baohanh, soluong, gia, hinh, nhasanxuat, ngaytao, madanhmuc);
if (listhang.ContainsKey(mahang))
{
Hang h = (Hang)listhang[mahang];
h.SoLuong += soluong;
}
else
{
listhang.Add(mahang, hang);
}
btnGioNhapHang.Text = String.Format("Phiếu nhập ({0})", listhang.Count);
}
public ActionResult Index(string ThongBao = null)
{
NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung;
if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND && d.DaXoa == false).FirstOrDefault() == null)
{
return(RedirectToAction("Index", "Login"));
}
var donHangDats = db.DonHangDats.Where(d =>
d.DaXoa == false &&
(d.TrangThai == "Đã đặt" || d.TrangThai == "Đang giao" || d.TrangThai == "Đã thanh toán")
).Include(d => d.KhachHang);
foreach (DonHangDat donHangDat in donHangDats)
{
if (donHangDat != null)
{
decimal tongDonHang = 0;
foreach (HangDonHangDat hangDonHangDat in donHangDat.HangDonHangDats)
{
Hang hang = db.Hangs.Where(d => d.MaH == hangDonHangDat.MaH).Include(d => d.MauHang).FirstOrDefault();
hangDonHangDat.Hang = hang;
tongDonHang += hangDonHangDat.SoLuong * hangDonHangDat.Hang.GiaBan;
}
donHangDat.TongDonHang = tongDonHang;
}
}
ViewBag.ThongBao = ThongBao;
return(View(donHangDats.ToList()));
}
public ActionResult Create(string guessedLetter)
{
char letter = Convert.ToChar(guessedLetter);
Hang.Guess(letter);
return(RedirectToAction("New", Hang.hiddenWord));
}
private void Text_Gia_TextChanged(object sender, EventArgs e)
{
TextBox txt_gia = sender as TextBox;
Hang hang = (Hang)listhang[txt_gia.Tag];
try
{
if (txt_gia.TextLength < 12)
{
hang.Gia = Convert.ToInt32(sanitizeString(txt_gia.Text));
}
else { txt_gia.Text = hang.Gia.ToString(); }
if (!txt_gia.Text.Equals("0"))
{
Label label_gia = listlabel[txt_gia.TabIndex];
label_gia.Text = formatCultureToString((hang.Gia * hang.SoLuong)) + " VNĐ";
txt_gia.Text = formatCultureToString(hang.Gia);
txt_gia.Select(txt_gia.TextLength, 0);
totalPaymentAmount();
}
}
catch(FormatException ex) { }
}
public async Task <IActionResult> Edit(int id, [Bind("Mahang,Tenhang")] Hang hang)
{
if (id != hang.Mahang)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(hang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HangExists(hang.Mahang))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(hang));
}
public void DeleteCTUpdateHang(string manx, string mah)
{
try {
using (QLCuaHangDataContext cuahang = new QLCuaHangDataContext()) {
//Cập nhật số lượng ở hàng.
ChiTiet c = cuahang.ChiTiets.SingleOrDefault(ct => ct.MaNX == manx && ct.MaHang == mah);
Hang h = cuahang.Hangs.SingleOrDefault(ha => ha.MaHang == c.MaHang);
if (manx.Substring(0, 1) == "N") //Xoá ChiTiet của Nhập.
{
h.GhiChu += "\n Ngày: " + DateTime.Now.ToString("dd/MM/yyyy") + " xoá Chi Tiết phiếu Nhập thay đổi sl: "
+ (h.SoLuong - c.SoLuong) + " => " + h.SoLuong;
h.SoLuong -= c.SoLuong;
}
else // Xoá ChiTiet của Xuất.
{
h.GhiChu += "\n Ngày: " + DateTime.Now.ToString("dd/MM/yyyy") + " xoá Chi Tiết phiếu Xuất thay đổi sl: "
+ (h.SoLuong + c.SoLuong) + " => " + h.SoLuong;
h.SoLuong += c.SoLuong;
}
//Tiến hành xoá chitiet.
cuahang.ChiTiets.DeleteOnSubmit(c);
cuahang.SubmitChanges();
}
}catch (Exception ex) { myme.ShowError(ex); }
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtMaHang.Text.Length == 0)
{
errMaHang.SetError(txtMaHang, "Không được để trống");
}
else
{
errMaHang.Clear();
}
if (txtTenHang.Text.Length == 0)
{
errTenHang.SetError(txtTenHang, "Không được để trống");
}
else
{
errTenHang.Clear();
}
if (txtMaLH.Text.Length == 0)
{
errMaLH.SetError(lblMaLH, "Không được để trống");
}
else
{
errMaLH.Clear();
}
if (txtMaNCC.Text.Length == 0)
{
errMaNCC.SetError(lblMaNCC, "Không được để trống");
}
else
{
errMaNCC.Clear();
}
if (errMaHang.GetError(txtMaHang).Length == 0 && errTenHang.GetError(txtTenHang).Length == 0 && errMaNCC.GetError(lblMaNCC).Length == 0 && errMaLH.GetError(lblMaLH).Length == 0)
{
Hang hang = new Hang();
hang.MaHang = txtMaHang.Text;
hang.DVT = txtDVT.Text;
hang.GhiChu = txtGhiChu.Text;
hang.MaLoaiHang = int.Parse(txtMaLH.Text);
hang.MaNCC = int.Parse(txtMaNCC.Text);
hang.TenHang = txtTenHang.Text;
if (HangBus.UpdateHang(hang))
{
MessageBox.Show("Cập nhật thánh công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
_frmHH.data = HangBus.GetListHang();
_frmHH.dgvHang.DataSource = _frmHH.data;
this.Close();
}
else
{
MessageBox.Show("Cập nhật thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public ActionResult TimKiem(string MaDHD, string DaDat, string DangGiao, string DaThanhToan)
{
NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung;
if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null)
{
return(RedirectToAction("Index", "Login"));
}
bool khongTimKiemTrangThai = true;
bool timKiemDaDat = false;
bool timKiemDangGiao = false;
bool timKiemDaThanhToan = false;
if (DaDat != null)
{
khongTimKiemTrangThai = false;
timKiemDaDat = true;
}
if (DangGiao != null)
{
khongTimKiemTrangThai = false;
timKiemDangGiao = true;
}
if (DaThanhToan != null)
{
khongTimKiemTrangThai = false;
timKiemDaThanhToan = true;
}
var donHangDats = db.DonHangDats.Include(d => d.KhachHang).Include(d => d.HangDonHangDats).Where(d =>
(MaDHD == "" || d.MaDHD.Contains(MaDHD)) &&
(
khongTimKiemTrangThai ||
(timKiemDaDat && d.TrangThai == "Đã đặt") ||
(timKiemDangGiao && d.TrangThai == "Đang giao") ||
(timKiemDaThanhToan && d.TrangThai == "Đã thanh toán")
) &&
d.DaXoa == false
);
foreach (DonHangDat donHangDat in donHangDats)
{
if (donHangDat != null)
{
decimal tongDonHang = 0;
foreach (HangDonHangDat hangDonHangDat in donHangDat.HangDonHangDats)
{
Hang hang = db.Hangs.Where(d => d.MaH == hangDonHangDat.MaH).Include(d => d.MauHang).FirstOrDefault();
hangDonHangDat.Hang = hang;
tongDonHang += hangDonHangDat.SoLuong * hangDonHangDat.Hang.GiaBan;
}
donHangDat.TongDonHang = tongDonHang;
}
}
ViewBag.MaDHD = MaDHD;
ViewBag.DaDat = DaDat;
ViewBag.DangGiao = DangGiao;
ViewBag.DaThanhToan = DaThanhToan;
return(View("Index", donHangDats.ToList()));
}
public bool deleteHang(int?id)
{
Hang hang = db.Hangs.Find(id);
db.Hangs.Remove(hang);
db.SaveChanges();
return(true);
}
public ActionResult Xoa(string id)
{
MyDBContext db = new MyDBContext();
HangF hf = new HangF();
Hang model = hf.ChitietHang(id);
return(View(model));
}
public ActionResult DeleteConfirmed(string id)
{
Hang hang = db.Hangs.Find(id);
db.Hangs.Remove(hang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void UpdateHang(this Hang hang, HangViewModel hangVM)
{
hang.ID = hangVM.ID;
hang.TenHang = hangVM.TenHang;
hang.LoaiID = hangVM.LoaiID;
hang.NgayTao = hangVM.NgayTao;
hang.TrangThai = hangVM.TrangThai;
}
private void btnSuaHang_Click(object sender, EventArgs e)
{
if (Hoantac(btnSuaHang.Text))
{
int mahang = Int32.Parse(txtIDHang.Text);
String tenhang_ = txtTenHang.Text;
String thongso = txtThongSo.Text;
int baohanh = Int32.Parse(txtBaoHanh.Text);
int soluong = Int32.Parse(txtSoLuong.Text);
int gia = Int32.Parse(sanitizeString(txtGia_2.Text));
String ngaytao = DateTime.Now.ToString("yyyy-MM-dd");
String nhasanxuat = txtNhaSanXuat.Text;
int madm = (Int32)cbDanhMuc.SelectedValue;
string hinh = "";
if (isUpdateImage)
{
do
{
hinh = RandomString(10) + Path.GetExtension(picHang.ImageLocation);
} while (BUS_Hang.Instance.isExistsImage(hinh));
}
Hang hang = new Hang(mahang, tenhang_, thongso, baohanh, soluong, gia, hinh, nhasanxuat, ngaytao, madm);
int res = bus_hang.SuaBangHang(hang);
if (res > 0)
{
string oldFileName = dgvHang.CurrentRow.Cells["HINH"].Value.ToString();
if (oldFileName != hang.Hinh)
{
if (isUpdateImage)
{
if (File.Exists(BUS_Hang.Instance.pathImage + oldFileName) && oldFileName != "default.png")
{
File.Delete(BUS_Hang.Instance.pathImage + oldFileName);
}
File.Copy(picHang.ImageLocation, BUS_Hang.Instance.pathImage + hang.Hinh);
isUpdateImage = false;
}
configDGVHang();
}
MessageBox.Show("Sửa thành công");
}
else
{
MessageBox.Show("Sửa thất bại");
}
}
else
{
configDGVHang();
}
}
private void BtnXemChiTiet_Click(object sender, EventArgs e)
{
Button btnXem = sender as Button;
Hang hang=(Hang)listhang[btnXem.Tag];
frm_ChiTietHang formChiTietHang = new frm_ChiTietHang();
formChiTietHang.hang = hang;
formChiTietHang.ShowDialog();
}
public ActionResult AddInStock(string MaDHN, string MaH, string SoLuong)
{
var donHangNhap = db.DonHangNhaps.Where(d => d.MaDHN == MaDHN).FirstOrDefault();
Hang hang = db.Hangs.Single(d => d.MaH == MaH);
var HDHN = db.HangDonHangNhaps.Where(d => d.MaDHN == MaDHN && d.MaH == MaH).FirstOrDefault();
bool loi = false;
if (SoLuong == "")
{
ViewBag.Loi = "Chưa nhập số lượng!";
loi = true;
}
else if (int.Parse(SoLuong) <= 0)
{
ViewBag.Loi = "Số lượng phải lớn hơn 0!";
loi = true;
}
if (!loi)
{
if (HDHN != null)
{
HDHN.SoLuong += int.Parse(SoLuong);
}
else
{
HangDonHangNhap hangDonHangNhap = new HangDonHangNhap();
hangDonHangNhap.SoLuong = int.Parse(SoLuong);
hangDonHangNhap.MaH = MaH;
hangDonHangNhap.MaDHN = donHangNhap.MaDHN;
db.HangDonHangNhaps.Add(hangDonHangNhap);
}
db.SaveChanges();
}
donHangNhap.NhaCungCap = db.NhaCungCaps.Where(d => d.MaNCC == donHangNhap.MaNCC).FirstOrDefault();
donHangNhap.HangDonHangNhaps = db.HangDonHangNhaps.Where(d => d.MaDHN == donHangNhap.MaDHN).ToList();
decimal TongDonHang = 0;
foreach (var HangDonHangNhap in donHangNhap.HangDonHangNhaps)
{
HangDonHangNhap.Hang = db.Hangs.Where(d => d.MaH == HangDonHangNhap.MaH).FirstOrDefault();
HangDonHangNhap.Hang.MauHang = db.MauHangs.Where(d => d.MaMH == HangDonHangNhap.Hang.MaMH).FirstOrDefault();
TongDonHang = HangDonHangNhap.SoLuong * HangDonHangNhap.Hang.GiaNhap;
}
if (donHangNhap.KieuGiamGia == "%" && donHangNhap.GiamGia != null)
{
TongDonHang -= TongDonHang / 100 * decimal.Parse(donHangNhap.GiamGia);
}
else if (donHangNhap.KieuGiamGia == "VNĐ" && donHangNhap.GiamGia != null)
{
TongDonHang -= decimal.Parse(donHangNhap.GiamGia);
}
ViewBag.TongDonHang = TongDonHang;
ViewBag.MauHangs = db.MauHangs.Where(d => d.DaXoa == false).ToList();
ViewBag.Hangs = db.Hangs.Where(d => d.MaNCC == donHangNhap.MaNCC).Include(d => d.MauHang).ToList();
return(View("Create", donHangNhap));
}
public ActionResult TimKiem(string MaDHX, string TenKH, string NgayXuatBD, string NgayXuatKT, string KieuGiamGia)
{
NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung;
if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null)
{
return(RedirectToAction("Index", "Login"));
}
bool TimKiemNgayNhap = NgayXuatBD != "" && NgayXuatKT != "" ? true : false;
DateTime NgayXuatBDDate = new DateTime();
DateTime NgayXuatKTDate = new DateTime();
if (TimKiemNgayNhap)
{
NgayXuatBDDate = DateTime.ParseExact(NgayXuatBD, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
NgayXuatKTDate = DateTime.ParseExact(NgayXuatKT, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
var DonHangXuats = db.DonHangXuats.Include(DonHangNhap => DonHangNhap.KhachHang).Where(d =>
(MaDHX == "" || d.MaDHX.Contains(MaDHX)) &&
(TenKH == "" || d.KhachHang.HoTen.Contains(TenKH)) &&
(KieuGiamGia == null || d.KieuGiamGia.Contains(KieuGiamGia)) &&
((TimKiemNgayNhap && NgayXuatBDDate <= d.NgayXuat && d.NgayXuat <= NgayXuatKTDate) || !TimKiemNgayNhap) &&
d.DaXoa == false
);
decimal TongGiaTriXuat = 0;
foreach (DonHangXuat donHangXuat in DonHangXuats)
{
donHangXuat.TongDonHang = 0;
var hangDonHangXuats = db.HangDonHangXuats.Where(d => d.MaDHX == donHangXuat.MaDHX);
foreach (HangDonHangXuat hangDonHangXuat in hangDonHangXuats)
{
Hang hang = db.Hangs.Where(d => d.MaH == hangDonHangXuat.MaH).First();
donHangXuat.TongDonHang += hangDonHangXuat.SoLuong * hang.GiaBan;
}
// tinh giam gia
if (donHangXuat.KieuGiamGia != "" && donHangXuat.GiamGia != null)
{
if (donHangXuat.KieuGiamGia == "VNĐ")
{
donHangXuat.TongDonHang -= Math.Round(decimal.Parse(donHangXuat.GiamGia), 0);
}
else if (donHangXuat.KieuGiamGia == "%")
{
donHangXuat.TongDonHang -= Math.Round(donHangXuat.TongDonHang / 100 * decimal.Parse(donHangXuat.GiamGia), 0);
}
}
TongGiaTriXuat += donHangXuat.TongDonHang;
}
ViewBag.MaDHX = MaDHX;
ViewBag.TenKH = TenKH;
ViewBag.NgayNhapBD = NgayXuatBD;
ViewBag.NgayNhapKT = NgayXuatKT;
ViewBag.KieuGiamGia = KieuGiamGia;
return(View("Index", DonHangXuats));
}
private void btnHangSX_Click(object sender, EventArgs e)
{
frmHangSX Hang = null;
if (Hang == null || Hang.IsDisposed)
{
Hang = new frmHangSX();
}
Hang.ShowDialog();
}
private void Num_SoLuong_ValueChanged(object sender, EventArgs e)
{
NumericUpDown num_soluong = sender as NumericUpDown;
Hang hang = (Hang)listhang[num_soluong.Tag];
hang.SoLuong = (int)num_soluong.Value;
Label label_gia=listlabel[num_soluong.TabIndex];
label_gia.Text = formatCultureToString((hang.Gia * hang.SoLuong)) + " VNĐ";
totalPaymentAmount();
}
private void btnXoaHang2_Click(object sender, EventArgs e)
{
Hang h = new Hang();
h.MaHang = dgvHang.SelectedRows[0].Cells[0].Value.ToString();
frmXoaHang formXoaHang = new frmXoaHang(h);
formXoaHang.ShowDialog();
loadDuLieu();
}
public ActionResult Suahang(Hang hang, HttpPostedFileBase fileUpload)
{
Hang hangm = data.Hangs.SingleOrDefault(n => n.MaHangSanPham == hang.MaHangSanPham);
//ViewBag.MaDoChoi = dc.MaDoChoi;
var Tenhang = hang.TenHangSanPham;
hangm.TenHangSanPham = Tenhang;
data.SubmitChanges();
return(RedirectToAction("Hang"));
}
public ActionResult OrderStock(string MaKH, string MaH, string SoLuong)
{
KhachHang skhachHang = Session["khachHang"] as KhachHang;
if (skhachHang == null || db.KhachHangs.Where(d => d.MaKH == skhachHang.MaKH && d.DaXoa == false).FirstOrDefault() == null)
{
return(RedirectToAction("Index", "Login"));
}
if (SoLuong == "")
{
ViewBag.Loi = "Chưa nhập số lượng";
}
else
{
int sl = int.Parse(SoLuong);
Hang hang = db.Hangs.Where(d => d.MaH == MaH).FirstOrDefault();
DonHangDat donHangDat = db.DonHangDats.Where(d => d.MaKH == MaKH && d.TrangThai == "Đang đặt" && d.DaXoa == false).Include(d => d.HangDonHangDats).FirstOrDefault();
if (donHangDat != null)
{
HangDonHangDat hangDonHangDat = db.HangDonHangDats.Where(d => d.MaDHD == donHangDat.MaDHD && d.MaH == MaH).FirstOrDefault();
if (hangDonHangDat != null)
{
hangDonHangDat.SoLuong += sl;
}
else
{
HangDonHangDat hangDonHangDatMoi = new HangDonHangDat();
hangDonHangDatMoi.MaDHD = donHangDat.MaDHD;
hangDonHangDatMoi.MaH = MaH;
hangDonHangDatMoi.SoLuong = sl;
db.HangDonHangDats.Add(hangDonHangDatMoi);
}
ViewBag.SoLuongHangDat = donHangDat.HangDonHangDats.Count() + 1;
}
else
{
DonHangDat donHangDatMoi = new DonHangDat();
int count = db.DonHangDats.Count() + 1;
donHangDatMoi.MaDHD = "DHD" + count.ToString();
donHangDatMoi.MaKH = MaKH;
donHangDatMoi.NgayBatDau = DateTime.Now;
donHangDatMoi.TrangThai = "Đang đặt";
HangDonHangDat hangDonHangDatMoi = new HangDonHangDat();
hangDonHangDatMoi.MaDHD = donHangDatMoi.MaDHD;
hangDonHangDatMoi.MaH = MaH;
hangDonHangDatMoi.SoLuong = sl;
db.DonHangDats.Add(donHangDatMoi);
db.HangDonHangDats.Add(hangDonHangDatMoi);
ViewBag.SoLuongHangDat = 1;
}
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public void xoaHang(Hang h)
{
string sql = "delete from Hang where maHang=@maHang";
Connect.openConnect();
SqlCommand cmd = new SqlCommand(sql, Connect.connect);
cmd.Parameters.AddWithValue("maHang", h.MaHang);
cmd.ExecuteNonQuery();
Connect.closeConnect();
}
