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;
}
