public static bool delete(CongNoDaiLy congno) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { CONGNODAILY cn; cn = (from d in db.CONGNODAILies where d.masodaily.Equals(congno.MaSoDaiLy) && 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.CONGNODAILies.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 CongNoDaiLy.searchKeys()) { results.Add(request + pro); } return(Json(results, JsonRequestBehavior.AllowGet)); }
public static int add(CongNoDaiLy congno) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { CONGNODAILY cn; cn = (from c in db.CONGNODAILies where c.masodaily.Equals(congno.MaSoDaiLy) && 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 CONGNODAILY(); cn.masodaily = congno.MaSoDaiLy; cn.masosach = congno.MaSoSach; cn.soluong = congno.SoLuong; cn.dongia = congno.DonGia; cn.thang = congno.Thang; db.CONGNODAILies.InsertOnSubmit(cn); db.SubmitChanges(); return(1); } } } catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }