public bool Them_LoaiHangHoa(string tenloai) { string maloai = ""; int gtmoi = hanghoa_DAL.Count_LoaiHang() + 1; if (hanghoa_DAL.Count_LoaiHang() < 10) { maloai = "MLH00" + gtmoi.ToString(); } else { maloai = "MLH0" + gtmoi.ToString(); } LOAIHANG loai = new LOAIHANG(); loai.MaLoai = maloai; loai.TenLoai = tenloai; if (hanghoa_DAL.Them_LoaiHang(loai)) { return(true); } else { return(false); } }
public List <BuildQuery.IQueryFilter> GetFilters() { var result = new List <IQueryFilter>(); var refObj = new LOAIHANG(); if (!string.IsNullOrEmpty(this.MALOAI)) { result.Add(new QueryFilterLinQ { Property = ClassHelper.GetProperty(() => refObj.MALOAI), Value = this.MALOAI, Method = FilterMethod.Like }); } if (!string.IsNullOrEmpty(this.TENLOAI)) { result.Add(new QueryFilterLinQ { Property = ClassHelper.GetProperty(() => refObj.TENLOAI), Value = this.TENLOAI, Method = FilterMethod.Like }); } return(result); }
public async Task <IHttpActionResult> Delete(string id) { var result = new TransferObj <bool>(); LOAIHANG instance = await _service.Repository.FindAsync(id); if (instance == null) { return(NotFound()); } try { _service.Delete(instance.ID); int del = await _service.UnitOfWork.SaveAsync(); if (del > 0) { result.Data = true; result.Status = true; result.Message = "Xóa thành công bản ghi"; } else { result.Data = false; result.Status = false; result.Message = "Thao tác không thành công"; } } catch (Exception e) { result.Data = false; result.Status = false; result.Message = e.Message; } return(Ok(result)); }
//xóa public void xoaLoaiHang(string maloai) { LOAIHANG l = qlch.LOAIHANGs.Where(d => d.MALOAI == maloai).FirstOrDefault(); qlch.LOAIHANGs.DeleteOnSubmit(l); qlch.SubmitChanges(); }
public bool suabophan(string malh, string tenlh, string ghichu) { if (Ktkhoachinh(malh) == 1) { List <LOAIHANG> list = LoadLoaiHang(); LOAIHANG a = new LOAIHANG(); a = qllh.LOAIHANGs.Where(bp => bp.MALH == malh.Trim()).FirstOrDefault(); a.TENLH = tenlh; a.GHICHU = ghichu; foreach (LOAIHANG b in list) { if (b.MALH == malh) { qllh.LOAIHANGs.DeleteOnSubmit(b); qllh.SubmitChanges(); } } qllh.SubmitChanges(); return(true); } else { return(false); } }
// sửa public void SuaLoaiHang(string maloai, string manhomhang, string tenloai) { LOAIHANG l = qlch.LOAIHANGs.Where(d => d.MALOAI == maloai).FirstOrDefault(); l.MALOAI = maloai; l.MANHOMHANG = manhomhang; l.TENLOAI = tenloai; qlch.SubmitChanges(); }
//thêm loại hàng public void ThemLoaiHang(string maloai, string manhomhang, string tenloai) { LOAIHANG l = new LOAIHANG(); l.MALOAI = maloai; l.MANHOMHANG = manhomhang; l.TENLOAI = tenloai; qlch.LOAIHANGs.InsertOnSubmit(l); qlch.SubmitChanges(); }
public bool Them_LoaiHang(LOAIHANG lh) { try { qlhh.LOAIHANGs.InsertOnSubmit(lh); qlhh.SubmitChanges(); return(true); } catch { return(false); } }
public bool xoaLoaihang(string malh) { LOAIHANG a = new LOAIHANG(); a = qllh.LOAIHANGs.Where(bp => bp.MALH == malh.Trim()).FirstOrDefault(); if (a == null) { return(false); } qllh.LOAIHANGs.DeleteOnSubmit(a); qllh.SubmitChanges(); LoadLoaiHang(); return(true); }
public bool Update(LOAIHANG lh) { var loaihang = db.LOAIHANGs.SingleOrDefault(x => x.ma == lh.ma); if (loaihang != null) { loaihang.sapxep = lh.sapxep; loaihang.maloaiao = lh.maloaiao; loaihang.link = lh.link; loaihang.loai = lh.loai; db.SaveChanges(); return(true); } return(false); }
public async Task <IHttpActionResult> Put(string id, LOAIHANG instance) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != instance.ID) { return(BadRequest()); } var result = new TransferObj <LOAIHANG>(); if (id != instance.ID) { result.Status = false; result.Message = "Mã ID không hợp lệ"; return(Ok(result)); } try { var item = _service.Update(instance, null, null, false); int upd = await _service.UnitOfWork.SaveAsync(); if (upd > 0) { result.Status = true; result.Data = item; result.Message = "Cập nhật thành công"; } else { result.Status = false; result.Data = null; result.Message = "Thao tác không thành công"; } } catch (Exception e) { result.Data = null; result.Status = false; result.Message = e.Message; } return(Ok(result)); }
public ActionResult Edit(LOAIHANG lh) { if (ModelState.IsValid) { var dao = new LoaiHangDao(); string tenloaihang = Common.Utility.ChangeChar(lh.loai); lh.link = "/" + Common.Utility.ConvertTitle(tenloaihang); if (dao.Update(lh) == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Thêm thất bại"); } } return(View()); }
public bool themLoaihang(string malh, string tenlh, string ghichu) { if (Ktkhoachinh(malh) == 0) { LOAIHANG a = new LOAIHANG(); a.MALH = malh; a.TENLH = tenlh; a.GHICHU = ghichu; qllh.LOAIHANGs.InsertOnSubmit(a); qllh.SubmitChanges(); LoadLoaiHang(); return(true); } else { return(false); } }
public List <HANGHOA> getHangHoaWithTL(string tenLoai) { List <HANGHOA> listHH = new List <HANGHOA>(); LOAIHANG loai = new LOAIHANG(); string id = ""; foreach (LOAIHANG item in db.LOAIHANGs) { if (item.TENLOAI.Contains(tenLoai)) { id = item.MALOAI; foreach (HANGHOA hh in db.HANGHOAs) { if (hh.MALOAI.Contains(id)) { listHH.Add(hh); } } } } return(listHH); }
public int Insert(LOAIHANG lh) { db.LOAIHANGs.Add(lh); db.SaveChanges(); return(lh.ma); }