/// <summary> Method for getting a user's checklists. </summary>
/// <param name="user"> Incoming parameter that specifies checklists user. </param>
/// <returns> Returns the checklists associated with the user. </returns>
public List <CheckList> GetCheckLists(EquipCheckAppUser appUser)
{
List <CheckList> checkLists = null;
using (var db = new EquipCheckEntities())
{
var userID = appUser.UserID;
var checklistResults = from checklists in db.checklists
where checklists.user_id == userID
select checklists;
checkLists = new List <CheckList>();
foreach (checklist checklist in checklistResults)
{
CheckList checkList = new CheckList();
checkList.CheckListID = checklist.checklist_id;
checkList.CheckListName = checklist.checklist_name;
checkList.CheckListDesc = checklist.checklist_description;
checkList.TripName = checklist.trip_name;
checkList.TripDesc = checklist.trip_description;
checkList.TripDate = checklist.trip_date;
checkList.CheckListItemSummary = checklist.checklist_summary;
checkLists.Add(checkList);
}
appUser.AllCheckList = checkLists;
}
return(checkLists);
}
/// <summary> Method for adding an item to an existing EquipmentList. </summary>
/// <param name="user"> Incoming parameter that specifies User of the EquipmentList. </param>
/// <param name="list"> Specifies the EquipmentList. </param>
/// <param name="item"> Specifies the EquipmentItem. </param>
public void AddItemToEquipmentList(EquipCheckAppUser user, EquipmentList list, EquipmentItem item)
{
using (var db = new EquipCheckEntities()) {
equipment_items equipItem = new equipment_items()
{
item_name = item.EquipItemName,
item_description = item.EquipItemDesc,
list_id = list.EquipListID
};
db.equipment_items.Add(equipItem);
db.SaveChanges();
}
}
/// <summary> Method for storing an EquipmentList. </summary>
/// <param name="user"> Incoming parameter that specifies User of the EquipmentList. </param>
/// <param name="list"> Specifies the EquipmentList. </param>
public void StoreEquipmentList(EquipCheckAppUser user, EquipmentList list)
{
using (var db = new EquipCheckEntities())
{
equipment_lists equipList = new equipment_lists()
{
list_name = list.EquipListName,
list_description = list.EquipListDesc,
user_id = user.UserID
};
db.equipment_lists.Add(equipList);
db.SaveChanges();
}
}
/// <summary> Method for getting the user's equipment lists. </summary>
/// <param name="user"> Incoming parameter that specifes user of the equipment lists. </param>
/// <returns> Returns the user's equipment lists. </returns>
public List <EquipmentList> GetEquipmentLists(EquipCheckAppUser appUser)
{
List <EquipmentList> lists = null;
using (var db = new EquipCheckEntities())
{
var userID = appUser.UserID;
var equiplistResults = from equiplists in db.equipment_lists
where equiplists.user_id == userID
select equiplists;
lists = new List <EquipmentList>();
foreach (equipment_lists equiplist in equiplistResults)
{
EquipmentList list = new EquipmentList();
list.EquipListID = equiplist.list_id;
list.EquipListName = equiplist.list_name;
list.EquipListDesc = equiplist.list_description;
var listID = list.EquipListID;
var equipitemResults = from equipitems in db.equipment_items
where equipitems.list_id == listID
select equipitems;
List <EquipmentItem> items = new List <EquipmentItem>();
foreach (equipment_items equipitem in equipitemResults)
{
EquipmentItem item = new EquipmentItem();
item.EquipItemID = equipitem.item_id;
item.EquipItemName = equipitem.item_name;
item.EquipItemDesc = equipitem.item_description;
items.Add(item);
}
list.EquipListItems = items;
lists.Add(list);
}
appUser.AllEquipLists = lists;
}
return(lists);
}
/// <summary> Method for storing an EquipCheckAppUser to the local database. </summary>
/// <param name="user"> Specifies the EquipCheckAppUser. </param>
/// <returns> Returns user if stored successfully. </returns>
public EquipCheckAppUser StoreEquipCheckAppUser(EquipCheckAppUser appUser)
{
using (var db = new EquipCheckEntities())
{
var appUsername = appUser.Username;
var appUserPassword = appUser.Password;
// Check to see if username already exists
var userResults = from users in db.app_users
where users.username == appUsername
select users;
List <app_users> app_user = userResults.ToList <app_users>();
if (app_user.Count == 0)
{
app_users user = new app_users()
{
username = appUsername,
password = appUserPassword
};
db.app_users.Add(user);
db.SaveChanges();
// Retrieve Local User
userResults = from users in db.app_users
where users.username == user.username
select users;
app_user = userResults.ToList <app_users>();
appUser = new EquipCheckAppUser();
appUser.UserID = app_user[0].user_id;
appUser.Username = app_user[0].username;
appUser.Password = app_user[0].password;
}
else
{
appUser = null;
}
}
return(appUser);
}
/// <summary> Method for storing an CheckList. </summary>
/// <param name="appUser"> Incoming parameter that specifies User of CheckList. </param>
/// <param name="list"> Specifies the CheckList. </param>
public void StoreCheckList(EquipCheckAppUser appUser, CheckList list)
{
using (var db = new EquipCheckEntities())
{
checklist checkList = new checklist()
{
checklist_name = list.CheckListName,
checklist_description = list.CheckListDesc,
trip_name = list.TripName,
trip_description = list.TripDesc,
trip_date = list.TripDate,
checklist_summary = list.CheckListItemSummary,
user_id = appUser.UserID
};
db.checklists.Add(checkList);
db.SaveChanges();
}
}
/// <summary>
/// Method for retrieving user from the local database.
/// </summary>
/// <param name="appUser">Incoming EquipCheckAppUser</param>
/// <returns>Returns an EquipCheckAppUser or null if user is not found.</returns>
public EquipCheckAppUser GetLocalUser(EquipCheckAppUser appUser)
{
using (var db = new EquipCheckEntities()) {
var userResults = from users in db.app_users
where users.username == appUser.Username
select users;
List <app_users> app_user = userResults.ToList <app_users>();
if (app_user.Count > 0)
{
appUser = new EquipCheckAppUser();
appUser.UserID = app_user[0].user_id;
appUser.Username = app_user[0].username;
appUser.Password = app_user[0].password;
}
else
{
appUser = null;
}
}
return(appUser);
}
