public MovieDetailModel AddMovieDirectors(string DirectorFirstName, string DirectorLastName)
{
//bool status = false;
string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
MovieDetailModel DirObj = null;
try
{
conn.Open();
SqlCommand check = new SqlCommand("select count(*) from MovieDirectors where FirstName=@firstname and LastName=@lastname", conn);
check.Parameters.AddWithValue("firstname", DirectorFirstName);
check.Parameters.AddWithValue("lastname", DirectorLastName);
int num =(int)check.ExecuteScalar();
if (num == 0)
{
SqlCommand cmd = new SqlCommand("insert into MovieDirectors values (@firstname,@lastname)", conn);
cmd.Parameters.AddWithValue("firstname", DirectorFirstName);
cmd.Parameters.AddWithValue("lastname", DirectorLastName);
int res = cmd.ExecuteNonQuery();
//status = true;
SqlCommand id = new SqlCommand("select Id,FirstName,LastName from MovieDirectors where FirstName=@firstname and LastName=@lastname", conn);
id.Parameters.AddWithValue("firstname", DirectorFirstName);
id.Parameters.AddWithValue("lastname", DirectorLastName);
var reader = id.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
DirObj = new MovieDetailModel();
DirObj.DirectorGenerID = reader.GetInt32(reader.GetOrdinal("Id"));
DirObj.DirectorFirstName = reader.GetString(reader.GetOrdinal("FirstName"));
DirObj.DirectorLastName = reader.GetString(reader.GetOrdinal("LastName"));
DirObj.DataError = null;
}
}
else
{
DirObj = new MovieDetailModel();
DirObj.DirectorGenerID=-1;
}
}
catch (Exception exc)
{
HttpContext.Current.Session["ErrorMessage"] = exc.Message;
}
conn.Close();
return DirObj;
}
public string AddMovie(string MovieName,string DirectorName,string GenreName,int Rating, int Duration,int DVDcopy,int Cost)
{
if (ModelState.IsValid)
{
MoviesDetails dalObj = new MoviesDetails();
MovieDetailModel movieObject = new MovieDetailModel();
movieObject = dalObj.AddMovie(MovieName,DirectorName,GenreName,Rating,Duration,DVDcopy,Cost);
if (movieObject != null)
{
ViewBag.Message = "MovieId" + movieObject.MovieID;
return movieObject.MovieID.ToString();
}
}
return "false";
}
public string AddGenre(string GenreNameInput)
{
if (ModelState.IsValid)
{
MoviesDetails dalObj = new MoviesDetails();
MovieDetailModel genreObject = new MovieDetailModel();
genreObject = dalObj.AddMovieGenres(GenreNameInput);
if (genreObject != null)
{
ViewBag.Message = "GenreId" + genreObject.DirectorGenerID;
return genreObject.DirectorGenerID.ToString();
}
}
return "false";
}
public string AddDirector(string DirectorFirstName, string DirectorLastName)
{
if (ModelState.IsValid)
{
MoviesDetails DalObj = new MoviesDetails();
MovieDetailModel DirObject = new MovieDetailModel();
DirObject=DalObj.AddMovieDirectors(DirectorFirstName, DirectorLastName);
if (DirObject.DirectorGenerID != -1)
{
ViewBag.Message = "DirectorId" + DirObject.DirectorGenerID;
}
else
{
ViewBag.Messgae = "-1";
}
return DirObject.DirectorGenerID.ToString();
}
return "false";
}
public MovieDetailModel AddMovie(string MovieName, string DirectorName, string GenreName, int Rating, int Duration, int DVDcopy, int Cost)
{
string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
MovieDetailModel movieObj = null;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Movies values (@directorname,@genrename,@moviename,@rating,@duration,@dvdcopy,@cost)", conn);
cmd.Parameters.AddWithValue("directorname", DirectorName);
cmd.Parameters.AddWithValue("genrename", GenreName);
cmd.Parameters.AddWithValue("moviename", MovieName);
cmd.Parameters.AddWithValue("rating", Rating);
cmd.Parameters.AddWithValue("duration", Duration);
cmd.Parameters.AddWithValue("dvdcopy", DVDcopy);
cmd.Parameters.AddWithValue("cost", Cost);
int res = cmd.ExecuteNonQuery();
//status = true;
SqlCommand id = new SqlCommand("select Id,Name from Movies where Name=@moviename and MovieDirectorName=@directorname", conn);
id.Parameters.AddWithValue("moviename", MovieName);
id.Parameters.AddWithValue("directorname", DirectorName);
var reader = id.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
movieObj = new MovieDetailModel();
movieObj.MovieID = reader.GetInt32(reader.GetOrdinal("Id"));
movieObj.MovieName = reader.GetString(reader.GetOrdinal("Name"));
}
}
catch (Exception exc)
{
HttpContext.Current.Session["ErrorMessage"] = exc.Message;
}
conn.Close();
return movieObj;
}
public ActionResult Index(string DirectorFirstName, string DirectorLastName)
{
if (ModelState.IsValid)
{
MoviesDetails DalObj = new MoviesDetails();
MovieDetailModel DirObject = new MovieDetailModel();
DirObject=DalObj.AddMovieDirectors(DirectorFirstName, DirectorLastName);
if (DirObject!=null)
{
if (DirObject.DataError == null)
{
ViewBag.message = "Director ID " + DirObject.DirectorGenerID;
}
else
{
ViewBag.message ="-1";
}
return View();
}
}
return View();
}
public MovieDetailModel AddMovieGenres(string GenreNameInput)
{
string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
MovieDetailModel genreObj = null;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into MovieGenres values (@genrename)", conn);
cmd.Parameters.AddWithValue("genrename", GenreNameInput);
int res = cmd.ExecuteNonQuery();
//status = true;
SqlCommand id = new SqlCommand("select Id,GenreName from MovieGenres where GenreName=@genrename", conn);
id.Parameters.AddWithValue("genrename", GenreNameInput);
var reader = id.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
genreObj = new MovieDetailModel();
genreObj.DirectorGenerID = reader.GetInt32(reader.GetOrdinal("Id"));
genreObj.GenreNameInput = reader.GetString(reader.GetOrdinal("GenreName"));
}
}
catch (Exception exc)
{
HttpContext.Current.Session["ErrorMessage"] = exc.Message;
}
conn.Close();
return genreObj;
}
