public static int Delete(Guid id)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblUserProduct row = dc.tblUserProducts
.FirstOrDefault(up => up.Id == id);
if (row != null)
{
dc.tblUserProducts.Remove(row);
return(dc.SaveChanges());
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Update(UserProduct userProduct)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblUserProduct tbluserProduct = dc.tblUserProducts.FirstOrDefault(up => up.Id == userProduct.Id);
if (tbluserProduct != null)
{
tbluserProduct.UserId = userProduct.UserId;
tbluserProduct.ProductId = userProduct.ProductId;
tbluserProduct.Amount = userProduct.Amount;
tbluserProduct.Notes = userProduct.Notes;
tbluserProduct.InCart = userProduct.InCart;
return(dc.SaveChanges());
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static UserProduct LoadById(Guid id)
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblUserProduct exsitingRow = dc.tblUserProducts.FirstOrDefault(u => u.Id == id);
if (exsitingRow != null)
{
UserProduct uProduct = new UserProduct
{
Id = exsitingRow.Id,
UserId = exsitingRow.UserId,
ProductId = exsitingRow.ProductId,
ProductTitle = exsitingRow.tblProduct.Title,
InCart = exsitingRow.InCart,
Amount = exsitingRow.Amount,
Notes = exsitingRow.Notes,
//ProductAisle = exsitingRow.tblAisleProduct.Aisle
};
return(uProduct);
}
else
{
throw new Exception("Row was not found.");
}
}
}
public static int UpdateGroceryList(User user)
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblUser tbluser = dc.tblUsers.FirstOrDefault(u => u.Id == u.Id);
if (tbluser != null)
{
tbluser.FirstName = user.FirstName;
tbluser.LastName = user.LastName;
tbluser.Email = user.Email;
tbluser.UserPass = user.UserPass;
// Delete all the tblUserProduct rows and add back in.
var existing = dc.tblUserProducts.Where(up => up.UserId == user.Id);
dc.tblUserProducts.RemoveRange(existing);
List <tblUserProduct> tblUserProducts = new List <tblUserProduct>();
// Also make sense of the tblUserProducts
foreach (UserProduct up in user.GroceryList)
{
tblUserProduct tbluserproduct = new tblUserProduct();
tbluserproduct.Id = Guid.NewGuid();
tbluserproduct.UserId = user.Id;
tbluserproduct.ProductId = up.Id;
tbluserproduct.InCart = up.InCart;
tbluserproduct.Amount = up.Amount;
tbluserproduct.Notes = up.Notes;
tblUserProducts.Add(tbluserproduct);
}
dc.tblUserProducts.AddRange(tblUserProducts);
int result = dc.SaveChanges();
return(result);
}
else
{
throw new Exception("Row was not found!!");
}
}
}
public static User LoadByEmail(string email)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblUser tbluser = dc.tblUsers.FirstOrDefault(u => u.Email == email);
User user = new User();
if (tbluser != null)
{
user.Id = tbluser.Id;
user.FirstName = tbluser.FirstName;
user.LastName = tbluser.LastName;
user.Email = tbluser.Email;
user.UserPass = tbluser.UserPass;
tblUserProduct tbluserproduct = dc.tblUserProducts.FirstOrDefault(up => up.UserId == user.Id);
if (tbluserproduct != null)
{
user.GroceryList = UserProductManager.LoadByUserId(tbluser.Id);
}
return(user);
}
else
{
throw new Exception("Row was not found!!!!");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Insert(UserProduct userProduct)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblUserProduct up = new tblUserProduct();
up.Id = Guid.NewGuid();
up.UserId = userProduct.UserId;
up.ProductId = userProduct.ProductId;
up.Amount = userProduct.Amount;
up.Notes = userProduct.Notes;
up.InCart = userProduct.InCart;
dc.tblUserProducts.Add(up);
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}