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