public ActionResult ThemCTHD(int?MaCTHD)
{
ChiTietHopDong model = db.ChiTietHopDongs.Find(MaCTHD);
ViewBag.HD = db.HopDongs.ToList().OrderBy(n => n.SoHopDong);
ViewBag.MH = db.MatHangs.ToList().OrderBy(n => n.TenMatHang);
//ViewBag.MaHD = db.ChiTietHopDongs.Find(CTHD.MaHopDong);
return(View());
}
public void ThemChiTietHopDong(string maHD, string maChiec, string maBH, string thoiHan, string maBaoTri)
{
ChiTietHopDong cthd = new ChiTietHopDong();
cthd.MaHD = maHD;
cthd.MaChiec = maChiec;
cthd.MaBH = maBH;
cthd.ThoiHanBaoHiem = thoiHan;
cthd.MaBaoTri = maBaoTri;
xe.ThemChiTietHopDong(cthd);
}
//dùng để thêm cthd trong frmChiTietHopDong
public bool ThemCTHD(ChiTietHopDong cthd)
{
ChiTietHopDongDAL dal = new ChiTietHopDongDAL();
if (dal.KTTrung(cthd))
{
return(false);
}
else
{
return(dal.ThemCTHD(cthd));
}
}
public ActionResult SuaCTHopDong(int?MaCTHD)
{
ChiTietHopDong CTHD = db.ChiTietHopDongs.Find(MaCTHD);
ViewBag.HD = db.HopDongs.ToList().OrderBy(n => n.SoHopDong);
ViewBag.MH = db.MatHangs.ToList().OrderBy(n => n.TenMatHang);
if (CTHD == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(CTHD));
}
public ActionResult ThemPN(int?page)
{
int pageNumber = (page ?? 1);
int pageSize = 5;
ViewBag.ThanhVien = db.ThanhViens.ToList().OrderBy(n => n.FullName);
ViewBag.Kho = db.Khos.ToList().OrderBy(n => n.TenKho);
ViewBag.MaLoaiMH = new SelectList(db.LoaiMatHangs.ToList().OrderBy(n => n.TenLoaiMH), "MaLoaiMH", "TenLoaiMH");
ViewBag.MaHopDong = db.HopDongs.ToList().OrderBy(n => n.SoHopDong);
ViewBag.StateList = db.LoaiMatHangs;
ViewBag.StateList2 = db.HopDongs;
ViewBag.StateList3 = db.ThanhViens;
ViewBag.StateList4 = db.Khos;
var model = new ChiTietHopDong();
return(View(model));
}
private void btnThemDichVu_Click(object sender, EventArgs e)
{
try
{
ChiTietHopDong chiTietHopDong = new ChiTietHopDong();
DichVu dichVu = db.DichVus.Find(int.Parse(txtMaDichVu.Text.Split('-')[0]));
chiTietHopDong.GhiChu = txtGhiChu.Text;
chiTietHopDong.DiaChiLapDat = txtDiaChiLapDat.Text;
chiTietHopDong.DichVu = dichVu;
chiTietHopDongs.Add(chiTietHopDong);
LoadDtgv();
}
catch (Exception)
{
MessageBox.Show("Không thể thêm");
}
}
private void BtnThem_Click(object sender, EventArgs e)
{
ChiTietHopDongBAL bal = new ChiTietHopDongBAL();
ChiTietHopDong cthd = new ChiTietHopDong();
cthd.CMND = dgvTimNguoiThue.SelectedRows[0].Cells[2].Value.ToString();
cthd.MaHopDong = txtMaHopDong.Text;
if (bal.ThemCTHD(cthd))
{
MessageBox.Show("Thêm thành công");
ReadOnly();
CleanTxt();
LoadData();
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
//public void ThemXe(Xe xe)
//{
// db.spXe_Insert(xe.MaXe, xe.KieuXe, xe.TenXe, xe.HinhAnh, xe.SoLuong, xe.Mau, xe.LoaiDongCo, xe.MaLuc, xe.MomenXoan, xe.TocDoToiDa,
// xe.SuTangToc, xe.NgayNhap, xe.GiaXe, xe.MaGiamGia);
//}
//public void XoaXe(string maXe)
//{
// db.spXe_Delete(maXe);
//}
//public void CapNhatXe(Xe xe)
//{
// if(xe.MaGiamGia == "") db.spXe_Update(xe.MaXe, xe.KieuXe, xe.TenXe, xe.HinhAnh, xe.SoLuong, xe.Mau, xe.LoaiDongCo, xe.MaLuc, xe.MomenXoan, xe.TocDoToiDa,
// xe.SuTangToc, xe.NgayNhap, xe.GiaXe, null);
// else db.spXe_Update(xe.MaXe, xe.KieuXe, xe.TenXe, xe.HinhAnh, xe.SoLuong, xe.Mau, xe.LoaiDongCo, xe.MaLuc, xe.MomenXoan, xe.TocDoToiDa,
// xe.SuTangToc, xe.NgayNhap, xe.GiaXe, xe.MaGiamGia);
//}
#endregion
#region Bán hàng
public List <ChiTietHopDong> LayChiTietHopDong()
{
List <ChiTietHopDong> listCTHD = new List <ChiTietHopDong>();
var lstCTHD = db.spChiTietHD_SelectAll().ToList();
foreach (var n in lstCTHD)
{
ChiTietHopDong cthd = new ChiTietHopDong()
{
MaHD = n.MaHD,
MaChiec = n.MaChiec,
MaBH = n.MaBH,
ThoiHanBaoHiem = n.ThoiHanBaoHiem,
MaBaoTri = n.MaBaoTri
};
listCTHD.Add(cthd);
}
return(listCTHD);
}
public ActionResult ThemCTHD(ChiTietHopDong CTHD)
{
ViewBag.HD = db.HopDongs.ToList().OrderBy(n => n.SoHopDong);
ViewBag.MH = db.MatHangs.ToList().OrderBy(n => n.TenMatHang);
ViewBag.MaHD = db.ChiTietHopDongs.Find(CTHD.MaHopDong);
var count = db.ChiTietHopDongs.Count(n => n.MaHopDong == CTHD.MaHopDong && n.MaMatHang == CTHD.MaMatHang);
var hd = db.HopDongs.Find(CTHD.MaHopDong);
var ctx2 = (from ctx in db.ChiTietHopDongs
where CTHD.MaHopDong == ctx.MaHopDong
select new
{
ctx.MaCTHD,
ctx.MaMatHang,
ctx.MaHopDong,
ctx.SoLuong,
ctx.Gia,
thanhtien = ctx.SoLuong * ctx.Gia
}).AsEnumerable();
// ViewBag.a = ctx2.Sum(n => n.thanhtien);
if (ModelState.IsValid)
{
if (count == 0)
{
ViewBag.Message = 1;
db.ChiTietHopDongs.Add(CTHD);
db.SaveChanges();
Logging log = new Logging();
log.SaveLog(CTHD.HopDong.SoHopDong + "-" + CTHD.MatHang.TenMatHang + "-" + db.HanhDongs.Where(n => n.MaAction == 1).FirstOrDefault().TenAction, 1, int.Parse(Session["MaThanhVien"].ToString()));
hd.TongGiaHD = ctx2.Sum(n => n.thanhtien);
db.SaveChanges();
}
else
{
ViewBag.Message = 0;
}
}
return(RedirectToAction("XemDMHopDong", "DanhMuc"));
}
public ActionResult DatHang(FormCollection f)
{
try
{
Random rd = new Random();
int ma = rd.Next(2000);
hd = new HOPDONG();
List <TourDaDatViewModel> spdm = LayGioHang();
KHACHHANG kh = new KHACHHANG();
kh.MaKH = ma.ToString();
kh.TenKH = f["customer_name"].ToString();
kh.SDTKH = f["customer_phone"].ToString();
kh.Email = f["customer_email"].ToString();
kh.DCKH = f["customer_address"].ToString();
ql.KHACHHANGs.Add(kh);
ql.SaveChanges();
hd.MaHD = rd.Next(2000).ToString();
hd.MaKH = kh.MaKH;
hd.ThoiGianDat = DateTime.Now;
hd.TongTien = TongTien();
ql.HOPDONGs.Add(hd);
ql.SaveChanges();
foreach (var item in spdm)
{
ChiTietHopDong ctHD = new ChiTietHopDong();
ctHD.MaCT_HopDong = rd.Next(2000).ToString();
ctHD.MaHopDong = hd.MaHD;
ctHD.MaTour = item.matour;
ctHD.SLNguoiLon = item.slnguoilon;
ctHD.SLTreEm = item.sltreem;
ctHD.ThanhTien = item.thanhtien;
ql.ChiTietHopDongs.Add(ctHD);
}
ql.SaveChanges();
Session.Remove("GioHang");
}
catch
{
}
return(View(hd));
}
public ActionResult SuaCTHopDong(ChiTietHopDong CTHD)
{
ViewBag.HD = db.HopDongs.ToList().OrderBy(n => n.SoHopDong);
ViewBag.MH = db.MatHangs.ToList().OrderBy(n => n.TenMatHang);
var hd = db.HopDongs.Find(CTHD.MaHopDong);
var ctx2 = (from ctx in db.ChiTietHopDongs
where hd.MaHopDong == ctx.MaHopDong
select new
{
ctx.MaCTHD,
ctx.MaMatHang,
ctx.MaHopDong,
ctx.SoLuong,
ctx.Gia,
thanhtien = ctx.SoLuong * ctx.Gia
}).AsEnumerable();
//Thêm vào cơ sở dữ liệu
if (ModelState.IsValid)
{
ViewBag.Message = 1;
db.Entry(CTHD).State = EntityState.Modified;
db.SaveChanges();
Logging log = new Logging();
log.SaveLog(CTHD.HopDong.SoHopDong + "-" + CTHD.MatHang.TenMatHang + "-" + db.HanhDongs.Where(n => n.MaAction == 2).FirstOrDefault().TenAction, 2, int.Parse(Session["MaThanhVien"].ToString()));
hd.TongGiaHD = ctx2.Sum(n => n.thanhtien);
db.SaveChanges();
return(RedirectToAction("XemDMHopDong", "DanhMuc"));
}
return(View(CTHD));
}
public ActionResult XoaCTHopDong(int MaCTHD)
{
ChiTietHopDong CTHD = db.ChiTietHopDongs.Find(MaCTHD);
var hd = db.HopDongs.Find(CTHD.MaHopDong);
var ctx2 = (from ctx in db.ChiTietHopDongs
where hd.MaHopDong == ctx.MaHopDong
select new
{
ctx.MaCTHD,
ctx.MaMatHang,
ctx.MaHopDong,
ctx.SoLuong,
ctx.Gia,
thanhtien = ctx.SoLuong * ctx.Gia
}).AsEnumerable();
if (CTHD == null)
{
Response.StatusCode = 404;
return(null);
}
Logging log = new Logging();
log.SaveLog(CTHD.HopDong.SoHopDong + "-" + CTHD.MatHang.TenMatHang + "-" + db.HanhDongs.Where(n => n.MaAction == 3).FirstOrDefault().TenAction, 3, int.Parse(Session["MaThanhVien"].ToString()));
db.ChiTietHopDongs.Remove(CTHD);
db.SaveChanges();
hd.TongGiaHD = ctx2.Sum(n => n.thanhtien);
db.SaveChanges();
return(RedirectToAction("XemDMHopDong", "DanhMuc"));
}
public ActionResult DaCoThongTin()
{
try
{
Random rd = new Random();
int ma = rd.Next(2000);
hd = new HOPDONG();
List <TourDaDatViewModel> spdm = LayGioHang();
KhachHangViewModel kh = (KhachHangViewModel)Session[Constants.Constants.LOGIN_KHACHHANG];
CUSOTMER = kh;
hd.MaHD = rd.Next(2000).ToString();
hd.MaKH = kh.MaKH;
hd.ThoiGianDat = DateTime.Now;
hd.TongTien = spdm.Sum(t => t.thanhtien);
ql.HOPDONGs.Add(hd);
ql.SaveChanges();
foreach (var item in spdm)
{
ChiTietHopDong ctHD = new ChiTietHopDong();
ctHD.MaCT_HopDong = rd.Next(2000).ToString();
ctHD.MaHopDong = hd.MaHD;
ctHD.MaTour = item.matour;
ctHD.SLNguoiLon = item.slnguoilon;
ctHD.SLTreEm = item.sltreem;
ctHD.ThanhTien = item.thanhtien;
ql.ChiTietHopDongs.Add(ctHD);
}
ql.SaveChanges();
Session.Remove("GioHang");
MAHD = hd.MaHD;
}
catch
{
}
return(View(hd));
}
public ActionResult ThemPN(PhieuNhap pn, FormCollection f, DateTime ngaynhap)
{
ViewBag.ThanhVien = db.ThanhViens.ToList().OrderBy(n => n.FullName);
ViewBag.Kho = db.Khos.ToList().OrderBy(n => n.TenKho);
ViewBag.MaLoaiMH = new SelectList(db.LoaiMatHangs.ToList().OrderBy(n => n.TenLoaiMH), "MaLoaiMH", "TenLoaiMH");
ViewBag.MaHopDong = db.HopDongs.ToList().OrderBy(n => n.SoHopDong);
var count = db.PhieuNhaps.Count(n => n.TenPhieuN == pn.TenPhieuN);
if (ModelState.IsValid)
{
var chon = db.HopDongs.Where(p => p.MaHopDong == pn.MaHopDong).FirstOrDefault();
if (count == 0)
{
if (chon != null)
{
if (ngaynhap >= chon.NgayKy && ngaynhap <= chon.NgayKT)
{
db.PhieuNhaps.Add(pn);
db.SaveChanges();
string ids = f["dataput"];
char[] delimiterChars = { ' ', ',', '.', ':', '\t' };
string[] words = ids.Split(delimiterChars, System.StringSplitOptions.RemoveEmptyEntries);
foreach (string word in words)
{
if (word != " " || word != ",")
{
int a = Int32.Parse(word);
ChiTietPhieuNhap mhk = db.ChiTietPhieuNhaps.SingleOrDefault(n => n.MaHangNhap == a);
mhk.MaPhieuN = pn.MaPhieuN;
mhk.MaKho = pn.MaKho;
db.Entry(mhk).State = EntityState.Modified;
MatHang mh = db.MatHangs.Where(s => s.MaMatHang == mhk.MaMatHang && mhk.MaPhieuN == pn.MaPhieuN).FirstOrDefault();
mh.TongSoLuong = mh.TongSoLuong + mhk.SLHangTamN;
mh.Gia = mhk.GiaHangN;
mh.NgaySX = mhk.NgaySX;
mh.HanSD = mhk.HanSD;
db.Entry(mh).State = EntityState.Modified;
db.SaveChanges();
}
}
Logging log = new Logging();
log.SaveLog(pn.TenPhieuN + "-" + db.HanhDongs.Where(n => n.MaAction == 1).FirstOrDefault().TenAction, 1, int.Parse(Session["MaThanhVien"].ToString()));
return(RedirectToAction("XemPhieuNhap", "PhieuNhapXuat"));
}
else
{
ViewBag.Message = " Vui lòng nhập ngày trong khoảng " + chon.NgayKy + " đến " + chon.NgayKT;
ViewBag.ThanhVien = db.ThanhViens.ToList().OrderBy(n => n.FullName);
ViewBag.Kho = db.Khos.ToList().OrderBy(n => n.TenKho);
ViewBag.MaLoaiMH = new SelectList(db.LoaiMatHangs.ToList().OrderBy(n => n.TenLoaiMH), "MaLoaiMH", "TenLoaiMH");
ViewBag.HD = db.HopDongs.ToList().OrderBy(n => n.MaHopDong);
ViewBag.StateList = db.LoaiMatHangs;
ViewBag.StateList2 = db.HopDongs;
ViewBag.StateList3 = db.ThanhViens;
ViewBag.StateList4 = db.Khos;
var model = new ChiTietHopDong();
return(View(model));
}
}
else
{
ViewBag.Message = "khong co hop dong";
}
}
else
{
ViewBag.Message1 = "Tên phiếu đã tồn tại!!!";
ViewBag.ThanhVien = db.ThanhViens.ToList().OrderBy(n => n.FullName);
ViewBag.Kho = db.Khos.ToList().OrderBy(n => n.TenKho);
ViewBag.MaLoaiMH = new SelectList(db.LoaiMatHangs.ToList().OrderBy(n => n.TenLoaiMH), "MaLoaiMH", "TenLoaiMH");
ViewBag.HD = db.HopDongs.ToList().OrderBy(n => n.MaHopDong);
ViewBag.StateList = db.LoaiMatHangs;
ViewBag.StateList2 = db.HopDongs;
ViewBag.StateList3 = db.ThanhViens;
ViewBag.StateList4 = db.Khos;
var model = new ChiTietHopDong();
return(View(model));
}
}
return(View());
}
public void ThemChiTietHopDong(ChiTietHopDong cthd)
{
db.spChiTietHD_Insert(cthd.MaHD, cthd.MaChiec, cthd.MaBH, cthd.ThoiHanBaoHiem, cthd.MaBaoTri);
}
