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); }