public bool Insert(HOADONDV item)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
db.HOADONDVs.Add(item);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Begin(int id, DateTime tgbatdau, string tenkh)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.PHONGs
where s.ID == id && s.Deleted == 0
select s;
var sv = x.FirstOrDefault();
if (sv != null)
{
if (sv.StatusID != 1)
{
return(false);
}
sv.StatusID = 3; //busy
sv.TGStart = tgbatdau;
db.SaveChanges();
//bat dau thi tao hoa don dv
var item = new HOADONDV()
{
ID_Phong = id,
NgayGioLap = tgbatdau,
SoGio = 0,
TenKH = tenkh ?? "",
TongTien = 0
};
db.HOADONDVs.Add(item);
db.SaveChanges();
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Update(HOADONDV item)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.HOADONDVs
where s.ID == item.ID && s.Deleted == 0
select s;
var sv = x.FirstOrDefault();
if (sv != null)
{
sv.TenKH = item.TenKH;
sv.ID_Phong = item.ID_Phong;
db.SaveChanges();
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}