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 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"));
}
}
//Sparar ner profilsidan som XML.
public ActionResult SaveAsXML()
{
try
{
var id = ThisUser();
var ctx = new Gr8DbContext();
List <User> userList = new List <User>();
userList = ctx.Database.SqlQuery <User>("select * from Users where Id =" + id).ToList();
string downloadsPath = KnownFolders.Downloads.Path;
Debug.WriteLine(downloadsPath);
if (userList != null)
{
var path = Server.MapPath(@"~/Images/MyProfile.xml");
XmlSerializer mySerializer = new XmlSerializer(typeof(List <User>));
TextWriter myWriter = new StreamWriter(path, true);
mySerializer.Serialize(myWriter, userList);
myWriter.Close();
saveLocal();
}
return(RedirectToAction("MyProfile", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult Index()
{
try
{
var Users = new List <User>();
var ctx = new Gr8DbContext();
Users = ctx.Users.ToList();
var _user = new User();
foreach (var u in Users)
{
if (u.IdentityID == User.Identity.GetUserId())
{
_user = u;
}
}
var viewModel = new UserViewModel(_user)
{
Profiles = ctx.Database.SqlQuery <User>("select top 6 * from Users where Active = 'True' and IdentityID != '" + User.Identity.GetUserId() + "' order by newid()").ToList()
};
return(View(viewModel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
//Hämtar ID på den användare som är inloggad.
public int ThisUser()
{
try
{
var Users = new List <User>();
var ctx = new Gr8DbContext();
Users = ctx.Users.ToList();
int thisUserId = 0;
foreach (var u in Users)
{
if (u.IdentityID == User.Identity.GetUserId())
{
thisUserId = u.Id;
Console.WriteLine(thisUserId);
return(thisUserId);
}
}
return(0);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(0);
}
}
public ActionResult EditProfile(int id)
{
try
{
using (Gr8DbContext gr8Db = new Gr8DbContext())
{
return(View(gr8Db.Users.FirstOrDefault(o => o.Id == id)));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult DeletePost(int id)
{
try
{
var ctx = new Gr8DbContext();
ctx.Database.ExecuteSqlCommand("Delete from Posts where id = " + id);
return(RedirectToAction("MyProfile", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public static string WhoWroteTheMessage(int Id)
{
try
{
int friendId = Id;
var ctx = new Gr8DbContext();
string name = ctx.Database.SqlQuery <string>("select firstname + ' ' + lastname from users where id = " + friendId).FirstOrDefault();
return(name);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return("Okänd avsändare");
}
}
//Räknar alla friendrequests för att kunna visa dom på startsidan.
public static int CountFriendRequests(String _id)
{
try
{
var id = _id;
var ctx = new Gr8DbContext();
int count = ctx.Database.SqlQuery <int>("select count(*) from FriendRequests where ToUser = (Select Id From Users Where IdentityID = '" + id + "' and Accepted = 'False')").Sum();
return(count);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(0);
}
}
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"));
}
}
//Lägger till vald kategori på vald användare.
public ActionResult AddCategories(int Id, int friendId)
{
try
{
var categoryId = Id;
var ctx = new Gr8DbContext();
var myId = ThisUser();
int friendshipId = ctx.Database.SqlQuery <int>("Select Id from FriendRequests where FromUser = "******" and ToUser = "******" or FromUser = "******" and ToUser = "******"Insert into FriendInCategories Values(" + friendshipId + ", " + myId + ", " + categoryId + ")");
return(RedirectToAction("MyFriends", "Profile"));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult RemoveCategory(int Id)
{
try
{
int myId = ThisUser();
int friendId = Id;
var ctx = new Gr8DbContext();
ctx.Database.ExecuteSqlCommand("delete from FriendInCategories where userid = " + myId + " and FriendshipId in (Select id from FriendRequests where fromuser = "******" or touser = "******")");
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 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"));
}
}
//Söker igenom alla användare för att leta efter dem som har samma intressen, då är det en match.
public ActionResult MatchSearch()
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
var viewmodel = new SeachBarViewModel
{
User = ctx.Database.SqlQuery <User>("Select * From Users Where Id in (Select UserId From UserInterests Where Interest in (Select Interest From UserInterests Where UserId =" + MyId + ")) And Id !=" + MyId + " order by FirstName").ToList()
};
return(View(viewmodel));
}
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"));
}
}
//Söka efter alla användare på deras namn.
public ActionResult SearchBar(string search)
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
var lista = new SeachBarViewModel
{
User = ctx.Users.Where(x => x.FirstName.Contains(search) && x.Active == true && x.Id != MyId || search == null && x.Active == true && x.Id != MyId).OrderBy(i => i.FirstName).ToList()
};
return(View(lista));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
//Fyller kategorilistan med kategorier.
public ActionResult AddCategory(int Id)
{
try
{
var ctx = new Gr8DbContext();
var viewModel = new CategoryViewModel()
{
FriendId = Id,
CategoryList = ctx.Database.SqlQuery <Category>("Select * from categories").ToList()
};
return(View(viewModel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult AddInterests()
{
try
{
var ctx = new Gr8DbContext();
var viewModel = new InterestsViewModel()
{
Interest = new Interests(),
InterestsList = ctx.Database.SqlQuery <Interests>("Select * from Interests").ToList()
};
return(View(viewModel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult DeleteInterest()
{
try
{
var MyId = ThisUser();
var ctx = new Gr8DbContext();
var viewModel = new InterestsViewModel()
{
InterestsList = ctx.Database.SqlQuery <Interests>("Select * from Interests Where Id in(Select Interest From UserInterests Where UserId=" + MyId + ")").ToList()
};
return(View(viewModel));
}
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"));
}
}
//Hämtar ID på den som är inloggad.
public static int ThisUser(string _id)
{
var Users = new List <User>();
var ctx = new Gr8DbContext();
Users = ctx.Users.ToList();
int thisUserId = 0;
foreach (var u in Users)
{
if (u.IdentityID == _id)
{
thisUserId = u.Id;
Console.WriteLine(thisUserId);
return(thisUserId);
}
}
return(0);
}
public ActionResult MyProfile()
{
try
{
int id = ThisUser();
var ctx = new Gr8DbContext();
var viewModel = new MyProfileViewModel
{
MyUser = ctx.Users.Where(i => i.Id == id).FirstOrDefault(),
MyInterests = ctx.Database.SqlQuery <string>("Select Name from Interests join UserInterests on UserInterests.Interest=Interests.Id where UserInterests.UserId ='" + id.ToString() + "'").ToList(),
MyPosts = ctx.Posts.Where(i => i.WrittenTo == id).OrderByDescending(d => d.Datum).ToList()
};
return(View(viewModel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public ActionResult MyFriends()
{
try
{
var id = User.Identity.GetUserId();
var ctx = new Gr8DbContext();
var viewModel = new ProfileIndexViewModel
{
Users = ctx.Database.SqlQuery <User>("Select * From Users Where Users.Id in (Select ToUser From FriendRequests Where FromUser in (Select Id From Users Where IdentityID = '" + id + "' and Accepted = 'True')) or Users.Id in (Select FromUser From FriendRequests Where ToUser in (Select Id From Users Where IdentityID = '" + id + "' and Accepted = 'True')) and Active = 'True' order by FirstName")
.ToList(),
FriendsRequests = ctx.Database.SqlQuery <User>("Select * From Users Where Users.Id in (Select FromUser From FriendRequests Where ToUser in (Select Id From Users Where IdentityID = '" + id + "' and Accepted = 'False')) and Active = 'True' order by FirstName")
.ToList()
};
return(View(viewModel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
//Kollar om användaren man är inne på har samma intressen som sig själv, då är det en match.
public ActionResult MatchControl(int id)
{
try
{
var myId = ThisUser();
var ctx = new Gr8DbContext();
var viewmodel = new MatchControlViewModel
{
Interests = ctx.Database.SqlQuery <string>("Select Name From Interests Where Id in (Select Interest From UserInterests Where UserId=" + myId + ") And Id in (Select Interest From UserInterests Where UserId=" + id + ")").ToList(),
OtherUser = ctx.Users.Where(i => i.Id == id).FirstOrDefault()
};
return(View(viewmodel));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(View("Error"));
}
}
public static string GetCategory(int Id, string identityId)
{
try
{
int friendId = Id;
var ctx = new Gr8DbContext();
int myId = ctx.Database.SqlQuery <int>("Select Id from Users where identityId = '" + identityId + "'").FirstOrDefault();
string category = ctx.Database.SqlQuery <string>("Select CategoryName From Categories join FriendInCategories on Categories.Id = FriendInCategories.CategoryId join FriendRequests on FriendRequests.Id = FriendInCategories.FriendshipId where FriendRequests.FromUser = "******" or FriendRequests.ToUser = "******" and FriendInCategories.UserId = " + myId).FirstOrDefault();
if (category == null)
{
category = "Kattegorilös och utan klös";
}
return(category);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return("");
}
}
//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"));
}
}
public PostsController()
{
ctx = new Gr8DbContext();
}
