public string PhatSinhDatTruoc() { int n = 0; string str = "PD"; PhieuDat dt = db.PhieuDats.ToList().LastOrDefault(); if (dt != null) { string str1 = dt.MaDat.Substring(2); n = int.Parse(str1) + 1; if (n < 10) { str = str + "000" + n.ToString(); } else if (n < 100) { str = str + "00" + n.ToString(); } else if (n < 1000) { str = str + "0" + n.ToString(); } else if (n < 10000) { str = str + n.ToString(); } } else { str = "PD0001"; } return(str); }
public void LuuPhieuThueMoi(List <ePhieuThue> l) { int ma = chisoPhieuThue(); foreach (var item in l) { PhieuThue pt = new PhieuThue(); pt.MaThue = sinhMaPhieuThueTuSo(++ma); pt.MaDia = item.Madia; pt.MaKhachHang = item.Makhachhang; pt.TrangThaiPhi = item.Trangthaiphi; pt.TrangThaiThue = item.Trangthaithue; pt.NgayHenTra = item.Ngayhentra; pt.NgayMuon = item.Ngaymuon; pt.NgayTra = item.Ngaytra; pt.PhiTraMuon = item.Phitramuon; pt.GiaThue = item.Giathue; db.PhieuThues.InsertOnSubmit(pt); Dia d = db.Dias.Where(x => x.MaDia.Equals(item.Madia)).First(); d.TrangThaiDia = "Đã thuê"; PhieuDat pd = db.PhieuDats.Where(x => x.MaDia.Equals(pt.MaDia)).FirstOrDefault(); if (pd != null) { db.PhieuDats.DeleteOnSubmit(pd); } } db.SubmitChanges(); }
public int ThemDatTruoc(ePhieuDat input) { try { var td = db.PhieuDats.Where(x => x.MaTieuDe.Equals(input.MaTieuDe)).Where(y => y.MaKhachHang.Equals(input.MaKhachHang)).ToList(); if (td.Count <= 0) { PhieuDat pt = new PhieuDat(); pt.MaDat = PhatSinhDatTruoc(); pt.NgayDat = input.NgayDat; pt.TrangThai = "Đang đặt"; pt.MaKhachHang = input.MaKhachHang; pt.MaTieuDe = input.MaTieuDe; pt.MaDia = input.MaDia; db.PhieuDats.InsertOnSubmit(pt); db.SubmitChanges(); return(1); } else { return(-1); } } catch (Exception) { return(0); } }
public int xoaDatTruoc(string maphieu) { PhieuDat pd = db.PhieuDats.Where(x => x.MaDat.Equals(maphieu)).FirstOrDefault(); if (pd == null) { return(0); } db.PhieuDats.DeleteOnSubmit(pd); db.SubmitChanges(); return(1); }
public int updateGanDiaChoPhieuDatTruoc(string maphieu, string madia) { PhieuDat pd = db.PhieuDats.Where(x => x.MaDat.Equals(maphieu)).FirstOrDefault(); if (pd == null) { return(0); } pd.MaDia = madia; pd.TrangThai = "Đã có đĩa"; db.SubmitChanges(); return(1); }
public ePhieuDat layPhieuDatTheoMa(string maphieudat) { PhieuDat pd = db.PhieuDats.Where(x => x.MaDat.Equals(maphieudat)).FirstOrDefault(); ePhieuDat phieu = new ePhieuDat(); phieu.MaTieuDe = pd.MaTieuDe; phieu.MaDia = pd.MaDia; phieu.MaKhachHang = pd.MaKhachHang; phieu.MaPhieuDat = pd.MaDat; phieu.NgayDat = pd.NgayDat; phieu.TrangThai = pd.TrangThai; return(phieu); }
public bool ThemPhieuDat(ePhieuDat epd) { PhieuDat pd = new PhieuDat(); pd.IdPhieuDat = epd.IdPhieuDat; pd.NgayTao = epd.NgayTao; pd.IdKhachHang = epd.IdKhachHang; if (!db.PhieuDats.Contains(pd)) { db.PhieuDats.InsertOnSubmit(pd); db.SubmitChanges(); return(true); } return(false); }