// GET: Admin/TSql_Films/Create
public ActionResult Create()
{
TSql_Films model = new TSql_Films();
ViewBag.IDCategory = new MultiSelectList(db.TSql_Categorys.ToList(), "IDCategory", "CategoryName", model.TSql_Film_Category.Select(t => t.IDCategory).ToArray());
ViewBag.IDCountry = new SelectList(db.TSql_Country, "IDCountry", "CountryName");
return(View(model));
}
// GET: Admin/TSql_Films/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TSql_Films tSql_Films = await db.TSql_Films.FindAsync(id);
if (tSql_Films == null)
{
return(HttpNotFound());
}
return(View(tSql_Films));
}
// GET: Admin/TSql_Films/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TSql_Films tSql_Films = await db.TSql_Films.FindAsync(id);
if (tSql_Films == null)
{
return(HttpNotFound());
}
ViewBag.IDCategory = new MultiSelectList(db.TSql_Categorys.ToList(), "IDCategory", "CategoryName", tSql_Films.TSql_Film_Category.Select(t => t.IDCategory).ToArray());
return(View(tSql_Films));
}
// rating
public ActionResult Rate(int?idrate, int star)
{
if (idrate == null)
{
Response.StatusCode = 404;
}
TSql_Films tf = db.TSql_Films.Find(idrate);
float tmp = (float)tf.Rating;
Int32 tmpvote = (Int32)tf.Votes;
tf.Rating = ((tmp * tmpvote) + star) / (tmpvote + 1);
tf.Votes++;
db.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
// POST: Admin/TSql_Films/Delete/5
public async Task <ActionResult> DeleteConfirmed(int id, int[] IDCategory)
{
TSql_Films tSql_Films = await db.TSql_Films.FindAsync(id);
TSql_Films tmpFilm = db.TSql_Films.Find(tSql_Films.IDFilm);
//var removeitems = tmpFilm.TSql_Film_Category.Where(t => !IDCategory.Contains(t.IDCategory)).ToList();
var tmp = tmpFilm.TSql_Film_Category.Where(t => t.IDFilm == tSql_Films.IDFilm).ToList();
foreach (var i in tmp)
{
db.Entry(i).State = EntityState.Deleted;
}
db.TSql_Films.Remove(tSql_Films);
await db.SaveChangesAsync();
Session["countFilm"] = Int32.Parse(Session["countFilm"].ToString()) - 1;
return(RedirectToAction("Index"));
}
public ActionResult Details(int?id)
{
if (id == null)
{
Response.StatusCode = 404;
}
TSql_Films tSql_Film = db.TSql_Films.Find(id);
foreach (var tmp in tSql_Film.TSql_Film_Category)
{
Session["tmpdetails"] = tmp.IDCategory;
}
Session["tmpFilm"] = id;
if (tSql_Film == null)
{
return(HttpNotFound());
}
return(View(tSql_Film));
}
public async Task <ActionResult> Create([Bind(Include = "IDFilm,FilmName,Description,Time,Author,DateSubmited,Image,IDCountry,Rating,Views,LinkFilm,Trailer,Download,IDCategory,Votes")] TSql_Films tSql_Films, int[] IDCategory, HttpPostedFileBase fileimg)
{
if (ModelState.IsValid)
{
// add file img
var img = Path.GetFileName(fileimg.FileName);
var pathimg = Path.Combine(Server.MapPath("~/Content/images"), img);
if (fileimg == null)
{
ViewBag.Img = "Chose images";
return(View());
}
else if (System.IO.File.Exists(pathimg))
{
ViewBag.Img = "Images had exists";
}
else
{
fileimg.SaveAs(pathimg);
}
tSql_Films.Image = fileimg.FileName;
tSql_Films.DateSubmited = DateTime.Now;
db.TSql_Films.Add(tSql_Films);
await db.SaveChangesAsync();
foreach (var item in IDCategory)
{
TSql_Film_Category tfc = new TSql_Film_Category();
tfc.IDFilm = tSql_Films.IDFilm;
tfc.IDCategory = item;
tfc.DateUpdate = DateTime.Now;
tfc.DateCreate = DateTime.Now;
db.TSql_Film_Category.Add(tfc);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDCountry = new SelectList(db.TSql_Country, "IDCountry", "CountryName", tSql_Films.IDCountry);
return(View(tSql_Films));
}
public ActionResult Details_WatchFilm(int?id)
{
if (id == null)
{
Response.StatusCode = 404;
}
db.TSql_Films.Find(id).Views++;
db.SaveChanges();
TSql_Films tSql_Film = db.TSql_Films.Find(id);
History hs = new History();
if (Session["History"] == null)
{
Session["History"] = new List <History>();
}
List <History> his = Session["History"] as List <History>;
if (his.FirstOrDefault(t => t.IDFilm == id) == null)
{
History newItem = new History()
{
IDFilm = tSql_Film.IDFilm,
FilmName = tSql_Film.FilmName,
Image = tSql_Film.Image,
Rating = tSql_Film.Rating,
Votes = tSql_Film.Votes.Value,
DateSubmited = tSql_Film.DateSubmited
};
his.Add(newItem);
}
if (tSql_Film == null)
{
return(HttpNotFound());
}
return(View(tSql_Film));
}
public async Task <ActionResult> Edit([Bind(Include = "IDFilm,FilmName,Description,Time,Author,DateSubmited,Image,IDCountry,Rating,Views,LinkFilm,Trailer,Download, IDCategory")] TSql_Films tSql_Films, int[] IDCategory, HttpPostedFileBase fileimg)
{
if (ModelState.IsValid)
{
TSql_Films tmpFilm = db.TSql_Films.Find(tSql_Films.IDFilm);
if (fileimg != null)
{
var img = Path.GetFileName(fileimg.FileName);
var pathimg = Path.Combine(Server.MapPath("~/Content/images"), img);
if (fileimg == null)
{
ViewBag.Img = "Chose images";
return(View());
}
else if (System.IO.File.Exists(pathimg))
{
ViewBag.Img = "Images had exists";
}
else
{
fileimg.SaveAs(pathimg);
}
tmpFilm.Image = fileimg.FileName;
}
tmpFilm.FilmName = tSql_Films.FilmName;
tmpFilm.Description = tSql_Films.Description;
tmpFilm.Time = tSql_Films.Time;
tmpFilm.Author = tSql_Films.Author;
tmpFilm.LinkFilm = tSql_Films.LinkFilm;
tmpFilm.Download = tSql_Films.Download;
tmpFilm.Trailer = tSql_Films.Trailer;
tmpFilm.IDCountry = tSql_Films.IDCountry;
db.Entry(tmpFilm).State = EntityState.Modified;
await db.SaveChangesAsync();
if (tmpFilm != null)
{
// remove item
var removeitems = tmpFilm.TSql_Film_Category.Where(t => !IDCategory.Contains(t.IDCategory)).ToList();
foreach (var i in removeitems)
{
db.Entry(i).State = EntityState.Deleted;
}
// add item
var additems = IDCategory.Where(t => !tmpFilm.TSql_Film_Category.Select(x => x.IDCategory).Contains(t));
foreach (var item in additems)
{
TSql_Film_Category tfc = new TSql_Film_Category();
tfc.IDFilm = tmpFilm.IDFilm;
tfc.IDCategory = item;
tfc.DateUpdate = DateTime.Now;
db.TSql_Film_Category.Add(tfc);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.IDCountry = new SelectList(db.TSql_Country, "IDCountry", "CountryName", tSql_Films.IDCountry);
return(View(tSql_Films));
}
