public List <UserModel> GetUserList(int homeId)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var query = (from u in she.User
where u.HomeId == homeId
select new UserModel
{
FirstName = u.Name,
LastName = u.Surname,
UserName = u.UserName,
UserType = u.UserType,
HomeId = u.HomeId,
ID = u.Id
}).ToList();
return(query);
}
catch (Exception ex)
{
throw ex;
}
}
}
public UserModel GetUserFromDB(string userName, string password)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var userInfo = she.User.Where(x => x.UserName == userName && x.Password == password).FirstOrDefault();
if (userInfo != null)
{
return(new UserModel
{
FirstName = userInfo.Name,
LastName = userInfo.Surname,
UserName = userInfo.UserName,
ID = userInfo.Id,
HomeId = userInfo.HomeId,
UserType = userInfo.UserType
});
}
else
{
throw new Exception("User name or password is wrong");
}
}
catch (Exception ex)
{
throw ex;
}
}
}
public void CreateUser(UserModel user)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var query = she.User.Where(x => x.UserName == user.UserName && x.HomeId == user.HomeId).FirstOrDefault();
if (query == null)
{
she.User.Add(new User
{
Name = user.FirstName,
Surname = user.LastName,
UserName = user.UserName,
Password = user.Password,
HomeId = user.HomeId,
UserType = user.UserType
});
she.SaveChanges();
}
else
{
throw new Exception("User exist!");
}
}
catch (Exception ex)
{
throw ex;
}
}
}
private bool IsHomeNameExist(string homeName)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
var home = she.Home.Where(x => x.Name == homeName).FirstOrDefault();
if (home != null)
{
return(true);
}
else
{
return(false);
}
}
}
public void AddTask(TaskModel taskModel)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var task = she.Task.Add(new HMData.Task {
Name = taskModel.Name,
ResponsibleUserId = taskModel.ResponsibleUserId,
HomeId = taskModel.HomeId
});
she.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public HomeModel CreateHome(HomeModel homeModel)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
if (!IsHomeNameExist(homeModel.Name))
{
Home home = she.Home.Add(new Home {
Name = homeModel.Name,
Type = homeModel.Type
});
she.SaveChanges();
homeModel.ID = home.Id;
return(homeModel);
}
else
{
throw new Exception("Home name is already exist. Choose another name!");
}
}
}
public void AddActivity(ActivityModel activityModel)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var activity = she.Activity.Add(new Activity {
HomeId = activityModel.HomeId,
Name = activityModel.Name,
PlannedDate = activityModel.PlannedDate,
Attendees = activityModel.AttendeesString
});
she.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void AddShoppingItem(ShoppingModel shoppingModel)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
she.Shopping.Add(new Shopping
{
Name = shoppingModel.ItemName,
ResponsibleUserId = shoppingModel.ResponsibleUserId,
HomeId = shoppingModel.HomeId
});
she.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <FoodModel> GetConsumedFood(int homeId)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var query = (from f in she.Food
where f.HomeId == homeId && (f.ConsumedDate != null)
select new FoodModel
{
BuyDate = f.BuyDate,
FoodName = f.Name,
ConsumedDate = (DateTime)f.ConsumedDate
}).ToList();
return(query);
}
catch (Exception ex)
{
throw ex;
}
}
}
public void AddFood(FoodModel foodModel)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var food = she.Food.Add(new Food
{
Name = foodModel.FoodName,
BuyDate = foodModel.BuyDate,
BestBeforeDate = foodModel.BestBeforeDate,
HomeId = foodModel.HomeId,
ConsumedDate = foodModel.ConsumedDate
});
she.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <BillModel> GetBillNotPaid(int homeId)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var query = (from b in she.Bill
where b.HomeId == homeId && !b.IsPaid
select new BillModel
{
BillType = b.Type,
Amount = b.Amount,
PaymentDueDate = b.PaymentDueDate
}).ToList();
return(query);
}
catch (Exception ex)
{
throw ex;
}
}
}
public void SaveBill(BillModel billModel)
{
using (SweetHomeEntities she = new SweetHomeEntities())
{
try
{
var bill = she.Bill.Add(new Bill
{
Type = billModel.BillType,
Amount = billModel.Amount,
HomeId = billModel.HomeId,
PaymentDueDate = billModel.PaymentDueDate
});
she.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
