public static User LoadById(Guid id)
{
try
{
using (FoodOrderSystemEntities dc = new FoodOrderSystemEntities())
{
tblUser userRow = dc.tblUsers.FirstOrDefault(a => a.Id == id);
if (userRow != null)
{
return(new User
{
Id = userRow.Id,
FirstName = userRow.FirstName,
LastName = userRow.LastName,
Email = userRow.Email,
Phone = userRow.Phone,
Password = userRow.Password,
Addresses = UserAddressManager.LoadByUserId(id),
Payments = UserPaymentManager.LoadByUserId(id)
});
}
else
{
throw new Exception("Row not found...");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static User LoadByEmail(string email, string password)
{
try
{
using (FoodOrderSystemEntities dc = new FoodOrderSystemEntities())
{
tblUser userRow = dc.tblUsers.FirstOrDefault(a => a.Email == email && a.Password == password);
if (userRow != null)
{
return(new User
{
Id = userRow.Id,
FirstName = userRow.FirstName,
LastName = userRow.LastName,
Email = userRow.Email,
Phone = userRow.Phone,
Password = userRow.Password,
Addresses = UserAddressManager.LoadByUserId(userRow.Id),
Payments = UserPaymentManager.LoadByUserId(userRow.Id)
});
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <User> Load()
{
try
{
using (FoodOrderSystemEntities dc = new FoodOrderSystemEntities())
{
List <User> results = new List <User>();
dc.tblUsers.ToList().ForEach(p => results.Add(new User
{
Id = p.Id,
FirstName = p.FirstName,
LastName = p.LastName,
Email = p.Email,
Phone = p.Phone,
Password = p.Password,
Addresses = UserAddressManager.LoadByUserId(p.Id),
Payments = UserPaymentManager.LoadByUserId(p.Id)
}));
return(results);
}
}
catch (Exception ex)
{
throw ex;
}
}