public ActionResult EditProfile(int id, FormCollection profil)
{
try
{
using (Gr8DbContext gr8Db = new Gr8DbContext())
{
var result = gr8Db.Users.SingleOrDefault(o => o.Id == id);
result.FirstName = Request["FirstName"];
result.LastName = Request["LastName"];
string dateInput = Request["DateOfBirth"];
DateTime parsedDate = DateTime.Parse(dateInput);
result.DateOfBirth = parsedDate;
var lista1 = gr8Db.Database.SqlQuery <string>("Select Name From Interests");
var lista2 = gr8Db.Database.SqlQuery <string>("Select Name From Interests Join UserInterests On Interests.Id = UserInterests.Interest Where UserId ='" + id.ToString() + "'");
gr8Db.SaveChanges();
}
return(Redirect(Url.Action("MyProfile", "Profile")));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult AddImageForm(Image image)
{
try
{
int thisId = ThisUser();
string fileName = Path.GetFileNameWithoutExtension(image.ImageFile.FileName);
string fileExt = Path.GetExtension(image.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmdd") + fileExt;
image.ImgPath = "~/Images/UserImages/" + fileName;
image.Title = fileName;
image.UserId = thisId;
fileName = Path.Combine(Server.MapPath("~/Images/UserImages/"), fileName);
image.ImageFile.SaveAs(fileName);
var ctx = new Gr8DbContext();
ctx.Images.Add(image);
ctx.Database.ExecuteSqlCommand("Update Users Set ProfileImage = '" + image.ImgPath + "' where Id = '" + thisId.ToString() + "'");
ctx.SaveChanges();
return(RedirectToAction("MyProfile", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public string Send([FromBody] Posts thePost)
{
try
{
ctx.Posts.Add(thePost);
ctx.SaveChanges();
return("Meddelandet skickat");
}
catch {
return("Något gick fel!");
}
}
public ActionResult ActivateAccount()
{
try
{
int id = ThisUser();
var ctx = new Gr8DbContext();
ctx.Database.ExecuteSqlCommand("Update Users Set Active = 'True' Where Id =" + id);
ctx.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult AddUser(User model)
{
try
{
var ctx = new Gr8DbContext();
model.Active = true;
ctx.Users.Add(model);
ctx.SaveChanges();
return(Redirect(Url.Action("MyProfile", "Profile")));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult FriendRequest(int Id)
{
try
{
int myId = ThisUser();
int friendId = Id;
var ctx = new Gr8DbContext();
ctx.Database.ExecuteSqlCommand("Insert into FriendRequests values(" + myId + ", " + friendId + ", 'False') ");
ctx.SaveChanges();
return(RedirectToAction("MyFriends", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
//Ta bort det valda intresset från listan.
public ActionResult DeleteInterestFromList(int Id)
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
ctx.Database.ExecuteSqlCommand("Delete From UserInterests Where UserId=" + MyId + " And Interest=" + Id);
ctx.SaveChanges();
return(RedirectToAction("MyProfile", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult DenyFriendRequest(int?id)
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
ctx.Database.ExecuteSqlCommand("delete from FriendRequests Where FromUser = '******' and ToUser = '******'");
ctx.SaveChanges();
return(RedirectToAction("MyFriends", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult DeleteInterest(FormCollection profil)
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
string intresse = Request["Interest.Name"];
ctx.Database.ExecuteSqlCommand("Delete From UserInterests Where UserId=" + MyId + " And Interest=(Select Id From Interests where Name='" + intresse + "')");
ctx.SaveChanges();
return(RedirectToAction("MyProfile", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
//Lägger till intresset som man väljer från listan med redan befintliga intressen.
public ActionResult AddInterestFromList(int Id)
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
var intresse = ctx.Database.SqlQuery <string>("Select Name From Interests Where Id ='" + Id.ToString() + "'").FirstOrDefault();
var lista1 = ctx.Database.SqlQuery <string>("Select Name From Interests").ToList();
bool boolean = true;
foreach (var namn in lista1)
{
if (intresse.Equals(namn))
{
boolean = false;
}
}
if (boolean)
{
ctx.Database.ExecuteSqlCommand("Insert into Interests Values('" + intresse + "')");
ctx.Database.ExecuteSqlCommand("Insert into UserInterests Values(" + MyId + ", (Select Id From Interests Where Name='" + intresse + "'))");
}
else
{
ctx.Database.ExecuteSqlCommand("Insert into UserInterests Values(" + MyId + ", (Select Id From Interests Where Name='" + intresse + "'))");
}
ctx.SaveChanges();
return(RedirectToAction("MyProfile", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
//Profilsidan som visas när man går in på någon annans profilsida.
public ActionResult OtherProfile(int id)
{
try
{
var myId = ThisUser();
var time = DateTime.Now;
var ctx = new Gr8DbContext();
var viewModel = new OtherProfileViewModel
{
OtherUser = ctx.Users.Where(i => i.Id == id).FirstOrDefault(),
OtherUserInterests = ctx.Database.SqlQuery <string>("select Name from Interests join UserInterests on UserInterests.Interest=Interests.Id where UserInterests.UserId ='" + id.ToString() + "'").ToList(),
FriendControl = ctx.Database.SqlQuery <int>("Select Count(*) From FriendRequests Where FromUser = "******" and ToUser = "******" and Accepted = 'True' or ToUser = "******" and FromUser = "******" and Accepted = 'True'").Sum(),
FriendRequestControl = ctx.Database.SqlQuery <int>("Select Count(*) From FriendRequests Where FromUser = "******" and ToUser = "******" and Accepted = 'False' or ToUser = "******" and FromUser = "******" and Accepted = 'False'").Sum()
};
ctx.Database.ExecuteSqlCommand("Insert into Visitors Values (" + myId + ", " + id + ", '" + time + "')");
ctx.SaveChanges();
return(View(viewModel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
