public ActionResult Index()
{
EquipmentManagerEntities db = new EquipmentManagerEntities();
var model = new HomeModel();
var itemIds = Membership.RecentItemIds(User.Identity.GetUserName());
if (itemIds != null)
{
model.RecentParts = itemIds.Select(x => db.Parts.Find(x));
}
var installationIds = Membership.RecentInstallationIds(User.Identity.GetUserName());
if (installationIds != null)
{
model.RecentInstallations = installationIds.Select(x => db.Installations.Find(x));
}
var equipmentIds = Membership.RecentEquipmentIds(User.Identity.GetUserName());
if (equipmentIds != null)
{
model.RecentEquipment = equipmentIds.Select(x => db.Equipments.Find(x));
}
return(View(model));
}
public static List <int> RecentEquipmentIds(string userName)
{
EquipmentManagerEntities db = new EquipmentManagerEntities();
var user = db.Users.SingleOrDefault(x => x.UserName == userName);
return(user.RecentEquipmentIds);
}
public static bool IsUserInDatabase(string userName)
{
EquipmentManagerEntities db = new EquipmentManagerEntities();
var user = db.Users.SingleOrDefault(x => x.UserName == userName);
return(user != null);
}
public static void AddRecentEquipmentToUser(string userName, int equipmentId)
{
EquipmentManagerEntities db = new EquipmentManagerEntities();
var user = db.Users.SingleOrDefault(x => x.UserName.ToLower() == userName.ToLower());
user.AddRecentEquipment(equipmentId);
db.SaveChanges();
}
public static User GetOrCreateUser(string userName)
{
EquipmentManagerEntities db = new EquipmentManagerEntities();
User u = db.Users.SingleOrDefault(x => x.UserName.ToLower() == userName.ToLower());
if (u == null)
{
u = new User()
{
UserName = userName
};
db.Users.Add(u);
db.SaveChanges();
}
return(u);
}
