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