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()); } }