public ActionResult Edit(Guid id)
{
using (ProgrammesanaEntities1 db = new ProgrammesanaEntities1())
{
return(View(db.Files.Where(x => x.id == id).FirstOrDefault()));
};
}
public ActionResult Share(string username)
{
using (ProgrammesanaEntities1 dc = new ProgrammesanaEntities1())
{
return(View(dc.Users.Where(x => x.Username == username).FirstOrDefault()));
}
}
public ActionResult SaveUserProfile(User u)
{
/*ProgrammesanaEntities1 db = new ProgrammesanaEntities1();
* User user = db.Users.Where(x => x.Username == u.Username).FirstOrDefault();
*
* u.Name = u.Name;
* u.Surname = u.Surname;
* u.Username = u.Username;
* u.Password = u.Password;
* db.SaveChanges();
* db.Dispose();
* return Redirect("Users");*/
try
{
using (ProgrammesanaEntities1 dc = new ProgrammesanaEntities1())
{
var myUser = dc.Users.SingleOrDefault(x => x.Username == u.Username);
myUser.Name = u.Name;
myUser.Surname = u.Surname;
myUser.Username = u.Username;
myUser.Password = u.Password;
myUser.Email = u.Email;
dc.SaveChanges();
}
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Edit(User u)
{
try
{
using (ProgrammesanaEntities1 dc = new ProgrammesanaEntities1())
{
var myUser = dc.Users.SingleOrDefault(x => x.Username == u.Username);
myUser.Blocked = u.Blocked;
dc.SaveChanges();
}
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Delete(Guid id)
{
ProgrammesanaEntities1 db = new ProgrammesanaEntities1();
File file = db.Files.Find(id);
db.Uploads.RemoveRange(file.Uploads);
db.Files.Remove(file);
db.SaveChanges();
return(RedirectToAction("Files"));
/*Files.Where(x => x.id == f.id).FirstOrDefault();
* var uploads = db.Uploads.Where(b => b.File_id == e.id).AsEnumerable();
* foreach( var bk in uploads)
* {
* var b = bk;
* e.Uploads.Remove(b);
* }
* db.Files.Remove(e);
* db.SaveChanges();
* db.Dispose();*/
}
public ActionResult Edit(File file)
{
try
{
using (ProgrammesanaEntities1 db = new ProgrammesanaEntities1()){
var myFile = db.Files.Where(x => x.id == file.id).FirstOrDefault();
myFile.Title = file.Title;
myFile.Description = file.Description;
myFile.Date = file.Date;
myFile.Share = file.Share;
myFile.Categories_id = file.Categories_id;
db.SaveChanges();
}
return(RedirectToAction("Files"));
}
catch
{
return(View());
}
}
public ConnectionClass()
{
Entity = new ProgrammesanaEntities1();
}
