// GET api/values/5 public uvw_ProjectDetails Get(int id) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.uvw_ProjectDetails.FirstOrDefault(e => e.Project_ID == id)); } }
// GET api/values/5 public Users GetUserInfo() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.Users.FirstOrDefault(e => e.User_ID == UsersSecurity.user_id)); } }
public static string InsertNewAccount(string email, string password) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { try { entities.Users.Add(new Users { Email = email, Password = password, FirstName = "", LastName = "", Address = "", Username = "******" }); entities.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("SUCCESS"); }
// GET api/values/5 public SubCategories Get(int id) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.SubCategories.FirstOrDefault(e => e.SubCategory_ID == id)); } }
// GET: Project public IEnumerable <Projects> Get() { int test = UsersSecurity.user_id; using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { //return entities.Projects.ToList(); //return entities.Projects // .Include(b => b.Categories) // .Include(b => b.SubCategories) // .Include(b => b.Currencies) // .Include(b => b.Countries) // .Include(b => b.Rewards) // .ToList(); var projects = entities.Projects .Include(b => b.Categories) .Include(b => b.SubCategories) .Include(b => b.Currencies) .Include(b => b.Countries) .Include(b => b.Rewards) .ToList(); foreach (var item in projects) { item.Categories.Projects.Clear(); item.SubCategories.Projects.Clear(); item.Currencies.Projects.Clear(); item.Countries.Projects.Clear(); } return(projects); } }
public Backers GetBackersByUserID(int id) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.Backers.FirstOrDefault(e => e.User_ID == id)); } }
public string Post([FromBody] paymentValues values) { if (UsersSecurity.user_id == 0 || values == null) { return("FAIL"); } using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { try { entities.Backers.Add(new Backers { User_ID = UsersSecurity.user_id, Project_ID = values.pr_id, Amount = values.amount, DateCreated = DateTime.Now }); entities.SaveChanges(); } catch (Exception ex) { throw ex; } } return("SUCCESS"); }
public IEnumerable <Rewards> Get() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.Rewards .Include(b => b.Projects) .ToList()); } }
public List <Images> GetRewardsByProjectID(int id) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.Images .Include(b => b.Projects) .Where(e => e.Project_ID == id) .ToList()); } }
// GET: Project public IEnumerable <uvw_ProjectDetails> Get() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { // return entities.Projects.ToList(); return(entities.uvw_ProjectDetails .ToList()); } }
public List <Backers> GetBackersByProjectID(int id) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { return(entities.Backers .Include(b => b.Users) .Include(c => c.Projects) .Where(e => e.Project_ID == id) .ToList()); } }
// PUT api/userprofile/5 //[BasicAuthenticationAttributes] public void Put(string password) { var userId = 2; using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var user = entities.Users.FirstOrDefault(x => x.User_ID == userId); user.Password = password; entities.SaveChanges(); } }
public void Post(int id, [FromBody] Users user) { var userId = 2; using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var entity = entities.Users.FirstOrDefault(x => x.User_ID == userId); entity.Password = user.Password; entities.SaveChanges(); } }
public void Post([FromBody] Projects project)//[FromBody]Projects project { var userId = 2; using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { project.User_ID = userId; var entity = entities.Projects.Add(project); entities.SaveChanges(); } }
public IEnumerable <Backers> Get() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { //return entities.Categories.ToList(); return(entities.Backers .Include(a => a.Users) .Include(b => b.Projects) .ToList()); } }
public void Put(int id, [FromBody] updateProjectImg images) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var image = new Images { Data = Encoding.ASCII.GetBytes(images.image), Project_ID = id, ContentType = "dd" }; entities.Images.Add(image); entities.SaveChanges(); } }
// POST api/values //[BasicAuthenticationAttributes] public void Post([FromBody] Users user) { var userId = 2; using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var entity = entities.Users.FirstOrDefault(x => x.User_ID == userId); entity.FirstName = user.FirstName; entity.LastName = user.LastName; entity.Email = user.Email; entities.SaveChanges(); } }
// GET: Project public IEnumerable <Categories> Get() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var categories = entities.Categories.ToList(); foreach (var item in categories) { entities.Entry(item).State = EntityState.Detached; } return(categories); } }
public static bool Login(string email, string password) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { try { return(entities.Users.Any(user => user.Email.Equals(email, StringComparison.OrdinalIgnoreCase) && user.Password == password)); } catch (Exception ex) { return(false); } } }
// GET: Project public IEnumerable <SubCategories> Get() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { //return entities.SubCategories.ToList(); var subcategories = entities.SubCategories.ToList(); foreach (var item in subcategories) { entities.Entry(item).State = EntityState.Detached; } return(subcategories); } }
public static IEnumerable <object> ReturnCustomerDetails() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { try { return(entities.Users .Where(user => user.User_ID == UsersSecurity.user_id) .Select(user => new { user.FirstName, user.LastName, user.Email }) .ToList()); } catch (Exception ex) { throw ex; } } }
public static void SetUSerID(string email, string password) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { try { var result = entities.Users.Where(user => user.Email.Equals(email, StringComparison.OrdinalIgnoreCase) && user.Password == password) .Select(user => new { user.User_ID }).ToList(); user_id = result.First().User_ID; user_email = email; } catch (Exception ex) { throw ex; } } }
public void Put(int id, [FromBody] updateProject projects) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var entity = entities.Projects.FirstOrDefault(x => x.Project_ID == id); entity.Description = projects.description; entity.Title = projects.title; entity.Video = projects.video; entity.Category_ID = Int32.Parse(projects.category); entity.Subcategory_ID = Int32.Parse(projects.subcategory); entities.SaveChanges(); ProjectImagesController img = new ProjectImagesController(); ProjectImagesController.updateProjectImg bytes = new ProjectImagesController.updateProjectImg(); bytes.image = projects.image; img.Put(id, bytes); } }
// GET api/values/5 public Projects Get(int id) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { var project = entities.Projects .Include(b => b.Categories) .Include(b => b.SubCategories) .Include(b => b.Currencies) .Include(b => b.Countries) .Include(b => b.Rewards) .FirstOrDefault(e => e.Project_ID == id); project.Categories.Projects.Clear(); project.SubCategories.Projects.Clear(); project.Currencies.Projects.Clear(); project.Countries.Projects.Clear(); return(project); } }
public bool SetProjectOnEditMode(int id) { bool IsOK = false; int loggedInUserID = UsersSecurity.user_id; int projectUserID; if (loggedInUserID == 0) { IsOK = false; } else { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { projectUserID = (int)entities.Projects.Where(x => x.Project_ID == id).Select(v => v.User_ID).SingleOrDefault(); } IsOK = (projectUserID == loggedInUserID) ? true : false; } return(IsOK); }
// GET: Project public IEnumerable <uvw_ProjectDetails> Get() { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { /* * // return entities.Projects.ToList(); * var entities.Projects * .Where(b => b.user_id == UsersSecurity.user_id) * .ToList(); * return entities.uvw_ProjectDetails * .Where(b => b.project_id == var.project_id) * .ToList(); * var query = * from pr in entities.Projects * join meta in database.Post_Metas on post.ID equals meta.Post_ID * where post.ID == id * select new { pr_id = pr.project_id, us_id = UsersSecurity.user_id }; */ return(entities.uvw_ProjectDetails.ToList());; } }
public static string ExistingAccount(string email) { using (DreamFountainDBEntities entities = new DreamFountainDBEntities()) { try { if (entities.Users.Any(user => user.Email.Equals(email, StringComparison.OrdinalIgnoreCase))) { return("TRUE"); } else { return("FALSE"); } } catch (Exception ex) { return(ex.Message); } } }