public IEnumerable <Course> GetCourses()
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Courses.ToList());
}
}
public User UpdateMethodNotification(int userid, string radio)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
User u = db.Users.FirstOrDefault(i => i.Id == userid);
if (radio == "1")
{
u.ViaEmail = true;
u.ViaText = false;
}
if (radio == "2")
{
u.ViaText = true;
u.ViaEmail = false;
}
if (radio == "3")
{
u.ViaText = true;
u.ViaEmail = true;
}
AddAction(userid, "Update Notification Method settings", DateTime.Now);
db.SubmitChanges();
return(u);
}
}
public IEnumerable <UserOrganization> UserOrgItems(int orgid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.UserOrganizations.Where(i => i.OrgId == orgid).ToList());
}
}
public User UpdateNotification(int userid, string name, string phone, string email)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
User u = db.Users.FirstOrDefault(i => i.Id == userid);
Contact f = db.Contacts.FirstOrDefault(i => i.UserId == userid);
if (f == null)
{
Contact c = new Contact();
c.Name = name;
c.UserId = userid;
c.Email = email;
c.Phone = phone;
db.Contacts.InsertOnSubmit(c);
}
else
{
f.Name = name;
f.Email = email;
f.Phone = phone;
}
AddAction(userid, "Update Notification Contact settings", DateTime.Now);
db.SubmitChanges();
return(u);
}
}
public IEnumerable <ExpirationItem> GetExtraItems(int userid, int orgid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
var items = db.ItemShareWithCompanies.Where(i => i.OrgId == orgid && i.UserId == userid && i.Share == true);
var expirationItems = db.ExpirationItems.Where(o => o.UserId == userid).OrderBy(r => r.ExpirationDate);
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <ExpirationItem>(p => p.Category);
db.LoadOptions = loadOptions;
List <ExpirationItem> eitems = new List <ExpirationItem>();
foreach (ExpirationItem i in expirationItems)
{
foreach (ItemShareWithCompany j in items)
{
if (i.Id == j.ExpirationItemId)
{
eitems.Add(i);
break;
}
}
}
IEnumerable <ExpirationItem> updated = eitems;
return(updated.ToList());
}
}
public IEnumerable <Category> GetAllCategories()
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Categories.ToList());
}
}
public Image GetImageTwo(int itemid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Images.FirstOrDefault(i => i.ExpirationItemId == itemid && i.IsBack == true));
}
}
public IEnumerable <Action> GetAllActivity(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Actions.Where(i => i.UserId == userid).ToList());
}
}
public Contact GetContact(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Contacts.FirstOrDefault(i => i.UserId == userid));
}
}
public IEnumerable <ExpirationItem> GetAllExpirationItems(int UserId)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.ExpirationItems);
}
}
public IEnumerable <NonExpirationItem> GetAllNonExpirationItems(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.NonExpirationItems.Where(i => i.UserId == userid).ToList());
}
}
public IEnumerable <ExpirationItem> GetMemberDetails(int userid, int companyid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <ExpirationItem>(p => p.User);
loadOptions.LoadWith <User>(p => p.CoreCourses);
loadOptions.LoadWith <User>(p => p.Courses);
loadOptions.LoadWith <CoreCourse>(p => p.CourseCategory);
loadOptions.LoadWith <ExpirationItem>(p => p.Category);
db.LoadOptions = loadOptions;
IEnumerable <OrgRequiredItem> o = db.OrgRequiredItems.Where(i => i.OrgId == companyid);
IEnumerable <ExpirationItem> e = db.ExpirationItems.Where(i => i.UserId == userid);
List <ExpirationItem> list = new List <ExpirationItem>();
foreach (ExpirationItem i in e)
{
foreach (OrgRequiredItem r in o)
{
if (i.CategoryId == r.CatId)
{
list.Add(i);
}
}
}
return(list.ToList());
}
}
public void SetupMemberRel(string token, int?userid, int currentUserId)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
AddMemberToken a = db.AddMemberTokens.FirstOrDefault(i => i.Token == token);
UserOrganization u = new UserOrganization();
if (a.UserId == null)
{
u.UserId = userid.Value;
}
else
{
u.UserId = a.UserId.Value;
}
u.Date = DateTime.Now;
u.OrgId = a.OrgId;
u.Permission = a.Permission;
db.UserOrganizations.InsertOnSubmit(u);
User j = db.Users.FirstOrDefault(r => r.Id == u.UserId);
db.SubmitChanges();
DeleteToken(a.Id);
AddOrgAction(a.OrgId, currentUserId, j.FullName + " setup Relationship with you", DateTime.Now);
AddAction(u.UserId, "Setup Relationship with organization " + u.Organization.Name, DateTime.Now);
}
}
public NonExpirationItem GetNEExpirationItem(int itemid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.NonExpirationItems.FirstOrDefault(i => i.Id == itemid));
}
}
public Organization GetOrg(int companyid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Organizations.FirstOrDefault(i => i.Id == companyid));
}
}
public IEnumerable <Course> GetCoursePerUser(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
return(db.Courses.Where(i => i.UserId == userid));
}
}
public int GetPermission(int userid, int orgid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
var item = db.UserOrganizations.FirstOrDefault(i => i.OrgId == orgid && i.UserId == userid);
return(item.Permission.Value);
}
}
public User GetUser(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
User u = db.Users.FirstOrDefault(i => i.Id == userid);
return(u);
}
}
public int GetPermission(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
User u = db.Users.FirstOrDefault(i => i.Id == userid);
return(u.Permission);
}
}
public AddMemberToken GetToken(string token)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
AddMemberToken a = db.AddMemberTokens.FirstOrDefault(i => i.Token == token);
return(a);
}
}
public DateTime GetDateJoined(int userid, int orgid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
UserOrganization uo = db.UserOrganizations.FirstOrDefault(i => i.UserId == userid && i.OrgId == orgid);
return(uo.Date.Value);
}
}
public Organization GetOrganizationByUser(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
UserOrganization uo = db.UserOrganizations.FirstOrDefault(i => i.UserId == userid && i.Permission != 1);
return(db.Organizations.FirstOrDefault(i => i.Id == uo.OrgId));
}
}
public ExpirationItem GetExpirationItem(int itemid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
db.DeferredLoadingEnabled = false;
return(db.ExpirationItems.FirstOrDefault(i => i.Id == itemid));
}
}
public IEnumerable <User> GetAllUsers()
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
db.DeferredLoadingEnabled = false;
return(db.Users.ToList());
}
}
public Organization GetOrgForProfile(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
var item = db.UserOrganizations.FirstOrDefault(i => i.UserId == userid && i.Permission == 3);
return(db.Organizations.FirstOrDefault(i => i.Id == item.OrgId));
}
}
public User GetUserFromToken(string token)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
PasswordToken p = db.PasswordTokens.FirstOrDefault(i => i.guid == token);
return(db.Users.FirstOrDefault(i => i.Id == p.userid));
}
}
public User GetUser(string email)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
User i = db.Users.FirstOrDefault(u => u.Email == email);
return(i);
}
}
public void DeleteToken(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
PasswordToken p = db.PasswordTokens.FirstOrDefault(i => i.userid == userid);
db.PasswordTokens.DeleteOnSubmit(p);
db.SubmitChanges();
}
}
public void UpdateImage2(string gg, int identity, int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
Image i = db.Images.FirstOrDefault(j => j.ExpirationItemId == identity && j.IsBack == true);
i.Path = gg;
db.SubmitChanges();
}
}
public IEnumerable <Course> GetAllCourses(int userid)
{
using (DataLayerDataContext db = new DataLayerDataContext())
{
var loadOptions = new DataLoadOptions();
db.LoadOptions = loadOptions;
return(db.Courses.Where(i => i.UserId == userid).ToList());
}
}
