public bool editNFC(NFC objNFC)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idUser = Convert.ToInt32(objNFC.idUser);
int idScan = Convert.ToInt32(objNFC.idScan);
int StoreCNPJ = Convert.ToInt32(objNFC.StoreCNPJ);
NFCeEntity NFC = mdeEmarket.NFCeEntities.Single(p => p.idNF == objNFC.idNF &&
p.idUser == idUser &&
p.idScan == idScan);
NFC.idNF = objNFC.idNF;
NFC.idUser = idUser;
NFC.idScan = idScan;
NFC.StoreCNPJ = StoreCNPJ;
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool editProduct(Product Product)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
ProductEntity EntProduct = mdeEmarket.ProductEntities.Single(p => p.idStore == Product.idStore &&
p.idProduct == Product.idProduct);
EntProduct.idProduct = Product.idProduct;
EntProduct.idCategory = Product.idCategory;
EntProduct.idStore = Product.idStore;
EntProduct.ProductImportName = Product.ProductImportName;
EntProduct.Name = Product.Name;
EntProduct.Price = Product.Price;
EntProduct.Image = Product.Image;
EntProduct.LastUpdtDt = Product.LastUpdDt;
EntProduct.LastUpdtHr = Product.LastUpdHr;
EntProduct.AllBranch = Product.AllBranch;
EntProduct.QtdeNok = Product.QtdeNok;
EntProduct.QtdeOk = Product.QtdeOK;
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool editList(List List)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idList = Convert.ToInt32(List.idList);
int idUser = Convert.ToInt32(List.idUser);
ListEntity list = mdeEmarket.ListEntities.Single(p => p.idList == idList &&
p.idUser == idUser &&
p.idProductName == List.idProductName);
list.idList = idList;
list.idUser = idUser;
list.Name = List.Name;
list.idProductName = List.idProductName;
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool editUser(User objUser)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
UserEntity user = mdeEmarket.UserEntities.Single(p => p.idUser == objUser.iduser);
user.idUser = objUser.iduser;
user.FirstName = objUser.FirstName;
user.MiddleName = objUser.MiddleName;
user.LastName = objUser.LastName;
user.CNPJ = objUser.CNPJ;
user.CPF = objUser.CPF;
user.Email = objUser.Email;
user.Hash = objUser.Hash;
user.Picture = objUser.Picture;
mdeEmarket.UserEntities.Add(user);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool editUserScan(UserScan objUserScan)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
UserScanEntity userscan = mdeEmarket.UserScanEntities.Single(p => p.idScan == objUserScan.idScan &&
p.idProduct == objUserScan.idProduct &&
p.idUser == objUserScan.idUser);
userscan.idScan = objUserScan.idScan;
userscan.idUser = objUserScan.idUser;
userscan.idNF = objUserScan.idNF;
userscan.idProduct = objUserScan.idProduct;
userscan.idStore = objUserScan.idStore;
userscan.Status = objUserScan.Status;
userscan.Type = objUserScan.Type;
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public NFC findNFC(string id)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
return(mdeEmarket.NFCeEntities.Where(objNFC => objNFC.idNF == id).Select(objNFC => new NFC
{
idNF = objNFC.idNF,
idUser = objNFC.idUser,
idScan = objNFC.idScan
}).First());
}
}
public List <Category> findAllCategory()
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
return(mdeEmarket.CategoryEntities.Select(cat => new Category
{
idCategory = cat.idCategory,
idStore = cat.idStore,
Name = cat.Name
}).ToList());
}
}
public List <NFC> findAllNFC()
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
return(mdeEmarket.NFCeEntities.Select(NFC => new NFC
{
idNF = NFC.idNF,
idUser = NFC.idUser,
idScan = NFC.idScan,
StoreCNPJ = NFC.StoreCNPJ
}).ToList());
}
}
public Category findCategory(String id)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int idCategory = Convert.ToInt32(id);
return(mdeEmarket.CategoryEntities.Where(cat => cat.idCategory == idCategory).Select(cat => new Category
{
idCategory = cat.idCategory,
idStore = cat.idStore,
Name = cat.Name
}).First());
}
}
public List <List> findAllList()
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
return(mdeEmarket.ListEntities.Select(list => new List
{
idList = list.idList,
idUser = list.idUser,
Name = list.Name,
idProductName = list.idProductName
}).ToList());
}
}
public List <List> findListByUser(string idUser)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int id = Convert.ToInt32(idUser);
return(mdeEmarket.ListEntities.Where(list => list.idUser == id).Select(list => new List
{
idList = list.idList,
idUser = list.idUser,
Name = list.Name,
idProductName = list.idProductName
}).ToList());
}
}
public List <NFC> findNFCByUser(string idUser)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int id = Convert.ToInt32(idUser);
return(mdeEmarket.NFCeEntities.Where(objNFC => objNFC.idUser == id).Select(objNFC => new NFC
{
idNF = objNFC.idNF,
idUser = objNFC.idUser,
idScan = objNFC.idScan,
StoreCNPJ = objNFC.StoreCNPJ
}).ToList());
}
}
/***********************************************************************************************/
/**************************************** STORES ***********************************************/
public Store findStore(string id)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int idStore = Convert.ToInt32(id);
return(mdeEmarket.StoreEntities.Where(store => store.idStore == idStore).Select(store => new Store
{
idStore = store.idStore,
idBranch = store.idBranch,
CompanyName = store.CompanyName,
CNPJ = store.CNPJ,
Name = store.Name,
GPS = store.GPS
}).First());
}
}
public bool deleteUser(User objUser)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
UserEntity user = mdeEmarket.UserEntities.Single(p => p.idUser == objUser.iduser);
mdeEmarket.UserEntities.Remove(user);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/***********************************************************************************************/
/*********************************** USER_SCAN *************************************************/
public UserScan findUserScan(string id)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int idScan = Convert.ToInt32(id);
return(mdeEmarket.UserScanEntities.Where(userscan => userscan.idScan == idScan).Select(userscan => new UserScan
{
idScan = userscan.idScan,
idUser = userscan.idUser,
idNF = userscan.idNF,
idProduct = userscan.idProduct,
idStore = userscan.idStore,
Status = userscan.Status,
Type = userscan.Type
}).First());
}
}
public bool deleteStore(Store objStore)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
StoreEntity store = mdeEmarket.StoreEntities.Single(p => p.idStore == objStore.idStore &&
p.idBranch == objStore.idBranch);
mdeEmarket.StoreEntities.Remove(store);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteNFC(NFC objNFC)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
NFCeEntity NFC = mdeEmarket.NFCeEntities.Single(p => p.idNF == objNFC.idNF);
mdeEmarket.NFCeEntities.Remove(NFC);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteList(List List)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idList = Convert.ToInt32(List.idList);
ListEntity list = mdeEmarket.ListEntities.Single(p => p.idList == idList);
mdeEmarket.ListEntities.Remove(list);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/***********************************************************************************************/
/**************************************** USER *************************************************/
public User findUser(string id)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int idUser = Convert.ToInt32(id);
return(mdeEmarket.UserEntities.Where(user => user.idUser == idUser).Select(user => new User
{
iduser = user.idUser,
FirstName = user.FirstName,
MiddleName = user.MiddleName,
LastName = user.LastName,
CNPJ = user.CNPJ,
CPF = user.CPF,
Email = user.Email,
Hash = user.Hash,
Picture = user.Picture
}).First());
}
}
public bool deleteCategory(Category category)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idCategory = Convert.ToInt32(category.idCategory);
CategoryEntity cat = mdeEmarket.CategoryEntities.Single(p => p.idCategory == idCategory);
mdeEmarket.CategoryEntities.Remove(cat);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteProduct(Product Product)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
ProductEntity EntProduct = mdeEmarket.ProductEntities.Single(p => p.idStore == Product.idStore &&
p.idProduct == Product.idProduct);
mdeEmarket.ProductEntities.Remove(EntProduct);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteUserScan(UserScan objUserScan)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
UserScanEntity userscan = mdeEmarket.UserScanEntities.Single(p => p.idScan == objUserScan.idScan &&
p.idProduct == objUserScan.idProduct &&
p.idUser == objUserScan.idUser);
mdeEmarket.UserScanEntities.Remove(userscan);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool editCategory(Category category)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idCategory = Convert.ToInt32(category.idCategory);
int idStore = Convert.ToInt32(category.idStore);
CategoryEntity cat = mdeEmarket.CategoryEntities.Single(p => p.idCategory == idCategory);
cat.idCategory = idCategory;
cat.idStore = idStore;
cat.Name = category.Name;
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public List <Product> findProductByUser(Product Filter)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
return(mdeEmarket.ProductEntities.Where(product => product.idProduct == Filter.idProduct &&
product.Name.Contains(Filter.Name)).Select(product => new Product
{
idProduct = product.idProduct,
idCategory = product.idCategory,
idStore = product.idStore,
ProductImportName = product.ProductImportName,
Name = product.Name,
Price = product.Price,
Image = product.Image,
LastUpdDt = product.LastUpdtDt,
LastUpdHr = product.LastUpdtHr,
AllBranch = product.AllBranch,
QtdeNok = product.QtdeNok,
QtdeOK = product.QtdeOk
}).ToList());
}
}
/***********************************************************************************************/
/**************************************** LIST *************************************************/
public bool createList(List List)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idList = Convert.ToInt32(List.idList);
int idUser = Convert.ToInt32(List.idUser);
ListEntity list = new ListEntity();
list.idList = idList;
list.idUser = idUser;
list.Name = List.Name;
list.idProductName = List.idProductName;
mdeEmarket.ListEntities.Add(list);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/***********************************************************************************************/
/**************************************** NFC **************************************************/
public bool createNFC(NFC objNFC)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
int idScan = Convert.ToInt32(objNFC.idScan);
int idUser = Convert.ToInt32(objNFC.idUser);
NFCeEntity entNFC = new NFCeEntity();
entNFC.idNF = objNFC.idNF;
entNFC.idUser = idUser;
entNFC.idScan = idScan;
entNFC.StoreCNPJ = objNFC.StoreCNPJ;
mdeEmarket.NFCeEntities.Add(entNFC);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/***********************************************************************************************/
/************************************* Product *************************************************/
public Product findProduct(string id)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
int idProduct = Convert.ToInt32(id);
return(mdeEmarket.ProductEntities.Where(Product => Product.idProduct == idProduct).Select(Product => new Product
{
idProduct = Product.idProduct,
idCategory = Product.idCategory,
idStore = Product.idStore,
ProductImportCode = Product.ProductImportCode,
ProductImportName = Product.ProductImportName,
Name = Product.Name,
Price = Product.Price,
Image = Product.Image,
LastUpdDt = Product.LastUpdtDt,
LastUpdHr = Product.LastUpdtHr,
AllBranch = Product.AllBranch,
QtdeNok = Product.QtdeNok,
QtdeOK = Product.QtdeOk
}).First());
}
}
public bool createStore(Store objStore)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
StoreEntity store = new StoreEntity();
store.idStore = objStore.idStore;
store.idBranch = objStore.idBranch;
store.Name = objStore.Name;
store.CompanyName = objStore.CompanyName;
store.CNPJ = objStore.CNPJ;
store.GPS = objStore.GPS;
mdeEmarket.StoreEntities.Add(store);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool editStore(Store objStore)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
StoreEntity store = mdeEmarket.StoreEntities.Single(p => p.idStore == objStore.idStore &&
p.idBranch == objStore.idBranch);
store.idStore = objStore.idStore;
store.idBranch = objStore.idBranch;
store.Name = objStore.Name;
store.CompanyName = objStore.CompanyName;
store.CNPJ = objStore.CNPJ;
store.GPS = objStore.GPS;
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool createUserScan(UserScan objUserScan)
{
using (EmarketEntities mdeEmarket = new EmarketEntities())
{
try
{
UserScanEntity userscan = new UserScanEntity();
userscan.idScan = objUserScan.idScan;
userscan.idUser = objUserScan.idUser;
userscan.idNF = objUserScan.idNF;
userscan.idProduct = objUserScan.idProduct;
userscan.idStore = objUserScan.idStore;
userscan.Status = objUserScan.Status;
userscan.Type = objUserScan.Type;
mdeEmarket.UserScanEntities.Add(userscan);
mdeEmarket.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}