public static bool delete(CongNoNXB congno)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
CONGNONXB cn;
cn = (from d in db.CONGNONXBs
where d.masonxb.Equals(congno.MaSoNXB) &&
d.masosach.Equals(congno.MaSoSach) &&
d.thang.Month.Equals(congno.Thang.Month) &&
d.thang.Year.Equals(congno.Thang.Year)
select d).SingleOrDefault();
if (cn == null)
{
return(false); //Nếu đại lý không tồn tại
}
db.CONGNONXBs.DeleteOnSubmit(cn);
db.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public JsonResult GetPropertiesChiTietNo(string request)
{
List <string> results = new List <string>();
foreach (string pro in CongNoNXB.searchKeys())
{
results.Add(request + pro);
}
return(Json(results, JsonRequestBehavior.AllowGet));
}
public static int add(CongNoNXB congno)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
CONGNONXB cn;
cn = (from c in db.CONGNONXBs
where c.masonxb.Equals(congno.MaSoNXB) &&
c.masosach.Equals(congno.MaSoSach) &&
c.thang.Month.Equals(congno.Thang.Month) &&
c.thang.Year.Equals(congno.Thang.Year)
select c).SingleOrDefault();
if (cn != null)
{
cn.soluong += congno.SoLuong;
db.SubmitChanges();
return(1);
}
else
{
cn = new CONGNONXB();
cn.masonxb = congno.MaSoNXB;
cn.masosach = congno.MaSoSach;
cn.soluong = congno.SoLuong;
cn.dongia = congno.DonGia;
cn.thang = congno.Thang;
db.CONGNONXBs.InsertOnSubmit(cn);
db.SubmitChanges();
return(1);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
public CongNoNXB Delete(CongNoNXB congNoNXB)
{
return(congNoNXBRepository.Delete(congNoNXB));
}
public void Update(CongNoNXB congNoNXB)
{
congNoNXBRepository.Update(congNoNXB);
}
public CongNoNXB Add(CongNoNXB congNoNXB)
{
return(congNoNXBRepository.Add(congNoNXB));
}
