private void ShowMovie_Load(object sender, EventArgs e) { ControllerMovie ctrlMovie = new ControllerMovie(); ModelMovie movie = ctrlMovie.GetOneMovie(ModelMovie.MovieID); labelMovieTitleValue.Text = movie.Title; labelDirectorValue.Text = movie.Director; labelCastValue.Text = movie.Cast; labelCountryValue.Text = movie.Country; labelYearValue.Text = movie.Year.ToString(); labelDescrValue.Text = movie.Description; }
public JsonResult SaveMovieDetails(ModelMovie mov) { string returnMessage = string.Empty; var uniqueFileName = ""; bool validExtension = false; if (Request.Files["PosterFile"] != null) { var file = Request.Files["PosterFile"]; var ext = System.IO.Path.GetExtension(file.FileName); List <string> fileExtensions = new List <string> { ".JPG", ".JPE", ".BMP", ".GIF", ".PNG" }; foreach (var f in fileExtensions) { if (f == ext.ToUpper()) { validExtension = true; break; } } if (validExtension) { uniqueFileName = Guid.NewGuid().ToString() + ext; var rootPath = Server.MapPath("~/Content/MoviePosters"); var filePath = System.IO.Path.Combine(rootPath, uniqueFileName); file.SaveAs(filePath); } else { returnMessage = "Upload a valid Image File"; } } CommonClass obj = new CommonClass(); if (returnMessage == "") { returnMessage = obj.saveMovieDetails(mov, uniqueFileName); return(Json(returnMessage, JsonRequestBehavior.AllowGet)); } else { return(Json(returnMessage, JsonRequestBehavior.AllowGet)); } }
private void EditMovies_Load(object sender, EventArgs e) { comboBoxCategory.Items.AddRange(ControllerCategory.LoadAllCategories()); ControllerMovie ctrlMovie = new ControllerMovie(); movie = ctrlMovie.GetOneMovie(id); textBoxTitle.Text = movie.Title; comboBoxCategory.SelectedIndex = Convert.ToInt32(movie.Category) - 1; textBoxDirector.Text = movie.Director; textBoxCast.Text = movie.Cast; textBoxCountry.Text = movie.Country; dateTimePickerYear.Value = new DateTime(movie.Year, 1, 1); textBoxDescr.Text = movie.Description; }
public string saveMovieDetails(ModelMovie _model, string uniqueFilePath) { string result = string.Empty; try { conn = ConntectionOpen(); SqlCommand cmd = new SqlCommand("Usp_Movies_AddEdit", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pUID", _model.UID); cmd.Parameters.AddWithValue("@pName", _model.Name); cmd.Parameters.AddWithValue("@pYearOfRelease", _model.YearOfRelease); if (_model.Producer == null) { return("Select Producer Again"); } cmd.Parameters.AddWithValue("@pProduderId", _model.Producer); cmd.Parameters.AddWithValue("@pActorsId", _model.Actors); cmd.Parameters.AddWithValue("@pPlot", _model.Plot); cmd.Parameters.AddWithValue("@pPosterPath", uniqueFilePath); cmd.Parameters.AddWithValue("@pInsertedBy", "Admin"); cmd.Parameters.AddWithValue("@pMode", _model.Mode); cmd.Parameters.Add("@pMsg", SqlDbType.NChar, 200); cmd.Parameters["@pMsg"].Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery().ToString(); string returnedfromDB = cmd.Parameters["@pMsg"].Value.ToString(); if (result != "1") { result = returnedfromDB; } } catch (Exception ex) { result = ex.Message.ToString(); } finally { conn.Close(); } return(result); }
public List <ModelMovie> DisplayMoviesPosters() { List <ModelMovie> list = new List <ModelMovie>(); try { using (cmd = new SqlCommand("Usp_Movies_AddEdit", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pMode", "SelectAll"); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; ModelMovie obj = new ModelMovie(); obj.UID = Convert.ToInt64(dr["UID"]); obj.Name = dr["Name"].ToString(); obj.YearOfRelease = dr["YearOfRelease"].ToString(); obj.Producer = dr["ProducerName"].ToString(); obj.Actors = dr["ActorName"].ToString(); obj.PosterFile = dr["PosterUrl"].ToString(); obj.Plot = dr["Plot"].ToString(); list.Add(obj); } } } } } catch (Exception ex) { } return(list); }
public PopularsController(ModelMovie db) { this.db = db; }
public MoviesController(ModelMovie dc) { this.dc = dc; }