public static bool Deleteitem(item iTem)
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
//xoa item
var dbiTem = (from u in _context.items
where u.itemcode == iTem.itemcode
select u).SingleOrDefault();
/*
* foreach (var x in dbiTem.listNCC)
* {
* foreach (var u in x.listitem)
* {
* if (u.itemcode == iTem.itemcode)
* {
* x.listitem.Remove(u);
* break;
* }
* }
* }
*/
//delete
_context.items.Remove(dbiTem);
_context.SaveChanges();
return(true);
}
}
public static bool UpdateNCC(NCC nCC)
{
try
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
/*
* foreach (var iTem in nCC.listitem)
* {
* var iTemdb = (from u in _context.items
* where u.itemcode == iTem.itemcode
* select u).Single();
* iTemdb.listNCC.Add(nCC);
* }
* nCC.listitem.Clear();
*/
_context.NCCs.AddOrUpdate(nCC);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool DeleteNCC(NCC nCC)
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
var dbnCC = (from u in _context.NCCs
where u.NCCcode == nCC.NCCcode
select u).SingleOrDefault();
_context.NCCs.Remove(dbnCC);
_context.SaveChanges();
return(true);
}
}
public static bool Updateitem(item iTem)
{
try
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
_context.items.AddOrUpdate(iTem);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static void initializeDB()
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
var iTem = new item {
itemcode = "ABC0123", itemname = "Mi tom", NSX = DateTime.Now, HSD = DateTime.Now, NNK = DateTime.Now
};
_context.items.Add(iTem);
var nCC = new NCC {
NCCcode = "123", NCCname = "Mien trung", NLDCC = DateTime.Now
};
_context.NCCs.Add(nCC);
_context.SaveChanges();
}
MessageBox.Show("finish");
}
public static bool AddNCC(NCC nCC)
{
/*
* using (var _context = new DBQuanLyBangBarcodeEntities())
* {
* if (nCC.listitem != null)
* {
* foreach (var iTem in nCC.listitem)
* {
* var itemdb = (from i in _context.items
* where i.itemcode == iTem.itemcode
* select i).Single();
* // itemdb.NCCs.Add(nCC);
* }
* }
* if (nCC.listitem != null)
* {
* nCC.listitem.Clear();
* }
* _context.NCCs.AddOrUpdate(nCC);
* _context.SaveChanges();
* return true;
* }
*/
try
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
_context.NCCs.Add(nCC);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool Additem(item iTem)
{
try
{
using (var _context = new DBQuanLyBangBarcodeEntities())
{
foreach (var nCC in iTem.listNCC)
{
var nCCbd = (from u in _context.NCCs
where u.NCCcode == nCC.NCCcode
select u).Single();
nCCbd.listitem.Add(iTem);
}
iTem.listNCC.Clear();
_context.items.AddOrUpdate(iTem);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}