public bool UpdateUser(user user)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
//Code first
//data.Entry(user).State = EntityState.Modified;
//data.SaveChanges();
//return true;
//////////// Code change
var getItem = data.users.Single(p => p.id == user.id);
getItem.id_role = user.id_role;
getItem.address = user.address;
getItem.email = user.email;
getItem.name = user.name;
getItem.password = user.password;
getItem.phone_number = user.phone_number;
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool DeleteExportBillByIdUser(int idUser)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var listExport = data.export_bill.Where(e => e.id_user == idUser).ToList();
foreach (var item in listExport)
{
var exportBill_Detail = data.export_bill_detail.Where(e => e.id_export_bill == item.id).ToList();
foreach (var item2 in exportBill_Detail)
{
data.export_bill_detail.Remove(item2);
}
data.export_bill.Remove(item);
}
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool UpdateProduct(product product)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
//data.products.Attach(product);
//data.Entry(product).State = EntityState.Modified;
//getItem.id = product.id;
var getItem = data.products.Single(p => p.id == product.id);//get the specific product
getItem.id_manufacturer = product.id_manufacturer;
getItem.id_save = product.id_save;
getItem.name = product.name;
getItem.sale_price = product.sale_price;
getItem.number = product.number;
getItem.image = product.image;
getItem.product_info = product.product_info;
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool DeleteUser(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var user = data.users.Single(u => u.id == id);
var exportBill = data.export_bill.Where(e => e.id_user == id).ToList();
foreach (var item in exportBill)
{
var exportBill_Detail = data.export_bill_detail.Where(e => e.id_export_bill == item.id).ToList();
foreach (var item2 in exportBill_Detail)
{
data.export_bill_detail.Remove(item2);
}
data.export_bill.Remove(item);
}
data.users.Remove(user);
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool DeleteExportBill_DetailByIdExportBill(int id_export)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
//var le = GetExportBill_DetailByIdExportBill(id_export).ToList();
var le = data.export_bill_detail.Where(e => e.id_export_bill == id_export).ToList();
if (le == null)
{
return(true);
}
foreach (var item in le)
{
data.export_bill_detail.Remove(item);
}
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool DeleteProduct(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var product = data.products.Single(p => p.id == id);
var exportBill_Detail = data.export_bill_detail.Where(e => e.id_product == id).ToList();
foreach (var item in exportBill_Detail)
{
data.export_bill_detail.Remove(item);
}
var importBill_Detail = data.import_bill_detail.Where(i => i.id_product == id).ToList();
foreach (var item in importBill_Detail)
{
data.import_bill_detail.Remove(item);
}
data.products.Remove(product);
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public List <product> GetProductByNameManu(string nameManu)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_product = data.products.AsNoTracking().Where(p => p.manufacturer.name == nameManu).ToList();
return(my_product);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public user GetUserById(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = data.users.First(s => s.id == id);
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <user> GetAllUser()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = (data.users.Select(p => p)).ToList();
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public export_bill_detail GetExportBill_DetailByBothId(int productId, int exportBillId)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = data.export_bill_detail.First(s => s.id_product == productId && s.id_export_bill == exportBillId);
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <export_bill_detail> GetAllExportBill_Detail()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = (data.export_bill_detail.Select(p => p)).ToList();
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public export_bill GetExportBillById(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = data.export_bill.First(s => s.id == id);
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public product GetProductById(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_product = data.products.First(s => s.id == id);
return(my_product);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <import_bill> GetImportBillByIdManu(int idManu)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = data.import_bill.AsNoTracking().Where(i => i.id_manufacturer == idManu).ToList();
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public role GetRoleWithId(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_save = data.roles.First(s => s.id == id);
return(my_save);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public Models.save_date GetSaveDateWithId(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_save = data.save_date.First(s => s.id == id);
return(my_save);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <role> GetAllRole()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_role = (data.roles.Select(p => p)).ToList();
return(my_role);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <save_date> GetSaveDateWithIdSave(int id_save)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_save = data.save_date.Where(s => s.id_save == id_save).ToList();
return(my_save);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <manufacturer> GetAllManufacturer()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_save = (data.manufacturers.Select(p => p)).ToList();
return(my_save);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <Models.save_date> GetAllSaveDate()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_save = (data.save_date.Select(p => p)).ToList();
return(my_save);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public manufacturer GetManufacturerById(int id)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_save = data.manufacturers.First(s => s.id == id);
return(my_save);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public bool UpdateRole(role s)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
data.Entry(s).State = EntityState.Modified;
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool AddRole(role s)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
data.roles.Add(s);
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public bool AddSaveDate(Models.save_date s)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
data.save_date.Add(s);
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public manufacturer GetManufacturerByName(string name)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_data = data.manufacturers.AsNoTracking()
.Where(m => m.name == name).FirstOrDefault();
return(my_data);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <product> GetProductByName(string n)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_product = data.products.AsNoTracking()
.Where(p => p.name.ToUpper().Contains(n) || p.name.ToLower().Contains(n)).ToList();
return(my_product);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public bool AddProduct(product product)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
data.products.Add(product);
data.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
public List <product> GetAllProduct()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_product = (data.products.Select(p => p)).ToList();
return(my_product);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <product> GetProductByIdManuAndNameProduct(int idManu, string namePro)
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_product = data.products.AsNoTracking()
.Where(p => p.id_manufacturer == idManu && p.name.Contains(namePro)).ToList();
return(my_product);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
public List <product> GetProductSave()
{
try
{
using (QLBH_PHONE_ENTITY data = new QLBH_PHONE_ENTITY())
{
var my_product = data.products.AsNoTracking()
.OrderByDescending(p => p.save.percent_save).Take(18).ToList();
return(my_product);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
