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