public ActionResult AddItem(Item item)
{
ViewBag.Message = "Add item";
List<Item> items = new List<Item>();
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
ctx.Items.Add(item);
ctx.SaveChanges();
items = ctx.Items.ToList();
}
return View("Items", items);
}
public ActionResult CreateFile(HttpPostedFileBase upload)
{
try
{
if (ModelState.IsValid)
{
if (upload != null && upload.ContentLength > 0)
{
var file = new File
{
FileName = System.IO.Path.GetFileName(upload.FileName),
FileType = FileType.Avatar,
ContentType = upload.ContentType
};
using (var reader = new System.IO.BinaryReader(upload.InputStream))
{
file.Content = reader.ReadBytes(upload.ContentLength);
}
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
ctx.Files.Add(file);
ctx.SaveChanges();
}
return RedirectToAction("Files");
}
}
}
catch (RetryLimitExceededException /* dex */)
{
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return View(new File());
}
public ActionResult GetFileContent(string id)
{
ViewBag.Message = "File";
File item;
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
item = ctx.Files.Find(int.Parse(id));
}
return File(item.Content, item.ContentType);
}
public ActionResult Items(IEnumerable<Item> items)
{
ViewBag.Message = "Your items";
if (items == null)
{
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
items = ctx.Items.ToList();
}
}
return View(items);
}
public ActionResult GetFile(string id)
{
ViewBag.Message = "File";
File item;
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
item = ctx.Files.Find(int.Parse(id));
}
return View(new ViewModelFile
{
Id = item.Id,
FileType = item.FileType,
FileName = item.FileName
});
}
//------------ FILES ---------------------------------
public ActionResult Files([Bind(Include = "FileName, ContentType, FileType")]IEnumerable<ViewModelFile> files)
{
ViewBag.Message = "Your files";
IEnumerable<ViewModelFile> vmfiles;
if (files == null)
{
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
var result = ctx.Files.ToList();
vmfiles = result.Select(fi => new ViewModelFile
{
Id = fi.Id,
FileName = fi.FileName,
ContentType = fi.ContentType,
FileType = fi.FileType
});
}
}
else
{
vmfiles = files.Select(fi => new ViewModelFile
{
Id = fi.Id,
FileName = fi.FileName,
ContentType = fi.ContentType,
FileType = fi.FileType
});
}
return View(vmfiles);
}
public ActionResult EditItem(Item item)
{
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
ctx.Entry(item).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
return View("EditItemConfirm", item);
}
//------------EDIT-----------------------------------
public ActionResult EditItem(string id)
{
ViewBag.Message = "Edit item";
Item item;
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
item = ctx.Items.Find(int.Parse(id));
}
return View(item);
}
public ActionResult DeleteItem(Item item)
{
// //set to delete
// http://stackoverflow.com/questions/15945172/the-object-cannot-be-deleted-because-it-was-not-found-in-the-objectstatemanager
ViewBag.Message = "Item was deleted.";
using (var ctx = new HunterDbContext(ConfigurationManager.AppSettings["AzureHunterDatabaseCnn"]))
{
ctx.Entry(item).State = System.Data.Entity.EntityState.Deleted;
ctx.Items.Remove(item);
ctx.SaveChanges();
}
return View("ItemWasDeleted", item);
}