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