public static ViewerProfileEntity SearchViewerProfileByIdDAL(int id)
{
ViewerProfileEntity searchViewerProfile = new ViewerProfileEntity();
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjViewerProfile = ObjContext.ViewerProfiles.Find(id);
if (ObjViewerProfile != null)
{
searchViewerProfile.ViewersId = ObjViewerProfile.ViewersId;
searchViewerProfile.FirstName = ObjViewerProfile.FirstName;
searchViewerProfile.LastName = ObjViewerProfile.LastName;
searchViewerProfile.MobileNo = ObjViewerProfile.MobileNo;
searchViewerProfile.EmailId = ObjViewerProfile.EmailId;
searchViewerProfile.UserName = ObjViewerProfile.UserName;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading searching data", ex);
}
return(searchViewerProfile);
}
//public static List<ViewerProfile> GetAllViewerProfilesDAL()
//{
// List<ViewerProfile> ObjViewerProfileList = new List<ViewerProfile>();
// try
// {
// CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
// var Query = from ViewerProfile in ObjContext.ViewerProfiles
// select ViewerProfile;
// ViewerProfile ObjTempViewerProfile = null;
// foreach (var obj in Query)
// {
// ObjTempViewerProfile = new ViewerProfile();
// ObjTempViewerProfile.ViewersId = obj.ViewersId;
// ObjTempViewerProfile.FirstName = obj.FirstName;
// ObjTempViewerProfile.LastName = obj.LastName;
// ObjTempViewerProfile.MobileNo = obj.MobileNo;
// ObjTempViewerProfile.EmailId = obj.EmailId;
// ObjTempViewerProfile.UserName = obj.UserName;
// ObjViewerProfileList.Add(ObjTempViewerProfile);
// }
// }
// catch (Exception ex)
// {
// throw new MovieExceptions("Error : Reading data", ex);
// }
// return ObjViewerProfileList;
//}
//public static bool UpdateViewerProfileDAL(ViewerProfile updateViewerProfile)
//{
// bool viewerProfileUpdated = false;
// try
// {
// CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
// var ObjViewerProfile = ObjContext.ViewerProfiles.Find(updateViewerProfile.ViewersId);
// if (ObjViewerProfile != null)
// {
// ObjViewerProfile.FirstName = updateViewerProfile.FirstName;
// ObjViewerProfile.LastName = updateViewerProfile.LastName;
// ObjViewerProfile.MobileNo = updateViewerProfile.MobileNo;
// ObjViewerProfile.EmailId = updateViewerProfile.EmailId;
// ObjViewerProfile.UserName = updateViewerProfile.UserName;
// int NoOfRowsAffected = ObjContext.SaveChanges();
// viewerProfileUpdated = NoOfRowsAffected > 0;
// }
// else
// {
// viewerProfileUpdated = false;
// }
// }
// catch (Exception ex)
// {
// throw new MovieExceptions(ex.Message);
// }
// return viewerProfileUpdated;
//}
public static ViewerProfileEntity SearchViewerProfileByUsernameDAL(string id)
{
ViewerProfileEntity searchViewerProfile = new ViewerProfileEntity();
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var query = from item in ObjContext.ViewerProfiles
where item.UserName.Equals(id)
select item;
ViewerProfile profile = query.FirstOrDefault();
int Viewerid = profile.ViewersId;
var ObjViewerProfile = ObjContext.ViewerProfiles.Find(Viewerid);
if (ObjViewerProfile != null)
{
searchViewerProfile.ViewersId = ObjViewerProfile.ViewersId;
searchViewerProfile.FirstName = ObjViewerProfile.FirstName;
searchViewerProfile.LastName = ObjViewerProfile.LastName;
searchViewerProfile.MobileNo = ObjViewerProfile.MobileNo;
searchViewerProfile.EmailId = ObjViewerProfile.EmailId;
searchViewerProfile.UserName = ObjViewerProfile.UserName;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading searching data", ex);
}
return(searchViewerProfile);
}
public static bool AddViewerProfilesDAL(ViewerProfileEntity newViewerProfile)
{
bool viewerProfileAdded = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjViewerProfile = new ViewerProfile();
ObjViewerProfile.FirstName = newViewerProfile.FirstName;
ObjViewerProfile.LastName = newViewerProfile.LastName;
ObjViewerProfile.MobileNo = newViewerProfile.MobileNo;
ObjViewerProfile.EmailId = newViewerProfile.EmailId;
ObjViewerProfile.UserName = newViewerProfile.UserName;
ObjContext.ViewerProfiles.Add(ObjViewerProfile);
int NoOfRowsAffected = ObjContext.SaveChanges();
if (NoOfRowsAffected > 0)
{
newViewerProfile.ViewersId = ObjViewerProfile.ViewersId;
viewerProfileAdded = true;
}
else
{
viewerProfileAdded = false;
}
}
catch (Exception ex)
{
throw new MovieExceptions(ex.Message);
}
return(viewerProfileAdded);
}
public static bool AddScreenLayout(int showId)
{
bool layoutAdded = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var objSeatLayout = new ShowSeatLayout();
objSeatLayout.ShowId = showId;
objSeatLayout.LayoutId = showId;
objSeatLayout.UnavailableSeats = string.Empty;
ObjContext.ShowSeatLayouts.Add(objSeatLayout);
int NoOfRowsAffected = ObjContext.SaveChanges();
if (NoOfRowsAffected > 0)
{
layoutAdded = true;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(layoutAdded);
}
public bool SignUpUserDAL(UserEntity newUser)
{
bool userAdded = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjUser = new User();
ObjUser.UserName = newUser.UserName;
ObjUser.Password = newUser.Password;
ObjContext.Users.Add(ObjUser);
int NoOfRowsAffected = ObjContext.SaveChanges();
if (NoOfRowsAffected > 0)
{
newUser.UserName = ObjUser.UserName;
userAdded = true;
}
else
{
userAdded = false;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(userAdded);
}
public bool AddMovieDAL(MovyEntity newMovie)
{
try
{
bool isAdded = false;
var ObjContext = new CinestarEntitiesDAL();
var objMovie = new Movy();
objMovie.MovieId = newMovie.MovieId;
objMovie.MovieName = newMovie.MovieName;
objMovie.MovieUrl = newMovie.MovieUrl;
objMovie.ReleaseDate = newMovie.ReleaseDate;
objMovie.GenreId = newMovie.GenreId;
objMovie.LanguageId = newMovie.LanguageId;
objMovie.MovieDescription = newMovie.MovieDescription;
ObjContext.Movies.Add(objMovie);
int NoOfrowsAffected = ObjContext.SaveChanges();
if (NoOfrowsAffected > 0)
{
isAdded = true;
}
return(isAdded);
}
catch (Exception Ex)
{
return(false);
}
}
public static ShowEntity SearchShowByIdDAL(int id)
{
ShowEntity searchShow = new ShowEntity();
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjShow = ObjContext.Shows.Find(id);
if (ObjShow != null)
{
searchShow.ScreenId = ObjShow.ScreenId;
searchShow.MovieId = ObjShow.MovieId;
searchShow.Price = ObjShow.Price;
searchShow.ShowDate = ObjShow.ShowDate;
searchShow.ShowId = ObjShow.ShowId;
searchShow.ShowTime = ObjShow.ShowTime;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading searching data", ex);
}
return(searchShow);
}
public bool CreateTicketDAL(TicketEntity newTicket)
{
bool ticketAdded = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
Ticket ObjTicket = new Ticket();
ObjTicket.NoOfTickets = newTicket.NoOfTickets;
ObjTicket.ShowId = newTicket.ShowId;
ObjTicket.Price = newTicket.Price;
ObjTicket.ViewersId = newTicket.ViewersId;
ObjTicket.TransactionDate = newTicket.TransactionDate;
ObjTicket.MovieId = newTicket.MovieId;
ObjTicket.Seats = newTicket.Seats;
ObjContext.Tickets.Add(ObjTicket);
int NoOfRowsAffected = ObjContext.SaveChanges();
if (NoOfRowsAffected > 0)
{
ticketAdded = true;
}
else
{
ticketAdded = false;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(ticketAdded);
}
public List <UserEntity> GetAllUsersDAL()
{
List <UserEntity> ObjUserList = new List <UserEntity>();
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var Query = from User in ObjContext.Users
select User;
UserEntity ObjTempUser = null;
foreach (var obj in Query)
{
ObjTempUser = new UserEntity();
ObjTempUser.UserName = obj.UserName;
ObjTempUser.Password = obj.Password;
ObjUserList.Add(ObjTempUser);
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(ObjUserList);
}
public List <ShowEntityNew> ViewAllShowsAdminDAL()
{
List <ShowEntityNew> result = new List <ShowEntityNew>();
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var Objshow = new ShowEntity();
var ObjMovieList = from Shows in ObjContext.Shows
join Movie in ObjContext.Movies
on Shows.MovieId equals Movie.MovieId
join Screen in ObjContext.Screens
on Shows.ScreenId equals Screen.ScreenId
select new ShowEntityNew
{
Movie = Movie.MovieName,
Screen = Screen.ScreenName,
Price = Shows.Price,
ShowDate = Shows.ShowDate,
ShowId = Shows.ShowId,
ShowTime = Shows.ShowTime
};
foreach (var item in ObjMovieList)
{
ShowEntityNew temp = new ShowEntityNew();
temp.Movie = item.Movie;
temp.Price = item.Price;
temp.Screen = item.Screen;
temp.ShowDate = item.ShowDate;
temp.ShowId = item.ShowId;
temp.ShowTime = item.ShowTime;
result.Add(temp);
}
return(result);
}
public bool DeleteShowDAL(int deleteShowID)
{
bool showDeleted = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var objShow = new Show();
objShow = ObjContext.Shows.Find(deleteShowID);
if (objShow != null)
{
ObjContext.Shows.Remove(objShow);
int NoOfRowsAffected = ObjContext.SaveChanges();
showDeleted = NoOfRowsAffected > 0;
}
else
{
showDeleted = false;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(showDeleted);
}
public bool UpdateShowDAL(ShowEntity updateShow)
{
bool showUpdated = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var objShow = new Show();
objShow = ObjContext.Shows.Find(updateShow.ShowId);
if (objShow != null)
{
objShow.ShowDate = updateShow.ShowDate;
objShow.ShowTime = updateShow.ShowTime;
objShow.MovieId = updateShow.MovieId;
objShow.Price = updateShow.Price;
objShow.ScreenId = updateShow.ScreenId;
int NoOfRowsAffected = ObjContext.SaveChanges();
showUpdated = NoOfRowsAffected > 0;
}
else
{
showUpdated = false;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(showUpdated);
}
public bool AddShowDAL(ShowEntity newShow)
{
bool showAdded = false;
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var Objshow = new Show();
Objshow.ShowDate = newShow.ShowDate;
Objshow.ShowTime = newShow.ShowTime;
Objshow.MovieId = newShow.MovieId;
Objshow.Price = newShow.Price;
Objshow.ScreenId = newShow.ScreenId;
ObjContext.Shows.Add(Objshow);
int NoOfRowsAffected = ObjContext.SaveChanges();
bool showLayoutAdded = ShowSeatLayoutDAL.AddScreenLayout(Objshow.ShowId);
if (NoOfRowsAffected > 0 && showLayoutAdded)
{
showAdded = true;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading data", ex);
}
return(showAdded);
}
public List <TicketEntityNew> MyTicketsDAL(int id)
{
var objcontext = new CinestarEntitiesDAL();
var query = from tickets in objcontext.Tickets
join movie in objcontext.Movies
on tickets.MovieId equals movie.MovieId
join show in objcontext.Shows
on tickets.ShowId equals show.ShowId
join viewer in objcontext.ViewerProfiles
on tickets.ViewersId equals viewer.ViewersId
where tickets.ViewersId == id
select new TicketEntityNew
{
Movie = movie.MovieName,
NoOfTickets = tickets.NoOfTickets,
Price = tickets.Price,
Seats = tickets.Seats,
ShowDate = show.ShowDate,
Ticketid = tickets.Ticketid,
TransactionDate = tickets.TransactionDate,
ViewerName = viewer.FirstName + " " + viewer.LastName
};
return(query.ToList());
}
public bool GiveFeedbackDAL(FeedbackEntity newFeedback)
{
try
{
bool isAdded = false;
var ObjContext = new CinestarEntitiesDAL();
var objFeedback = new Feedback();
objFeedback.FeedbackId = newFeedback.FeedbackId;
objFeedback.FeedbackDetails = newFeedback.FeedbackDetails;
objFeedback.ViewersId = newFeedback.ViewersId;
ObjContext.Feedbacks.Add(objFeedback);
int NoOfrowsAffected = ObjContext.SaveChanges();
if (NoOfrowsAffected > 0)
{
isAdded = true;
}
return(isAdded);
}
catch (Exception Ex)
{
return(false);
}
}
public List <FeedbackEntityNew> ViewAllFeedbackDAL()
{
var objcontext = new CinestarEntitiesDAL();
var query = from feedback in objcontext.Feedbacks
join viewer in objcontext.ViewerProfiles
on feedback.ViewersId equals viewer.ViewersId
select new FeedbackEntityNew {
Viewer = viewer.FirstName + " " + viewer.LastName,
FeedbackDetails = feedback.FeedbackDetails,
FeedbackId = feedback.FeedbackId
};
return(query.ToList());
}
public LanguageEntity SearchLanguage(int langId)
{
var ObjContext = new CinestarEntitiesDAL();
Language ObjLang = ObjContext.Languages.Find(langId);
LanguageEntity feedback = new LanguageEntity();
if (ObjLang != null)
{
feedback.LanguageId = ObjLang.LanguageId;
feedback.LanguageName = ObjLang.LanguageName;
}
return(feedback);
}
public GenreEntity SearchGenre(int genreId)
{
var ObjContext = new CinestarEntitiesDAL();
Genre ObjLang = ObjContext.Genres.Find(genreId);
GenreEntity genre = new GenreEntity();
if (ObjLang != null)
{
genre.GenreId = ObjLang.GenreId;
genre.GenreName = ObjLang.GenreName;
}
return(genre);
}
public static ShowSeatLayoutEntity ReturnSeatLayoutDAL(int showId)
{
CinestarEntitiesDAL cinestar = new CinestarEntitiesDAL();
var query = from item in cinestar.ShowSeatLayouts
where item.ShowId == showId
select item;
ShowSeatLayout layout = query.FirstOrDefault();
ShowSeatLayoutEntity entity = new ShowSeatLayoutEntity();
entity.LayoutId = layout.LayoutId;
entity.ShowId = layout.ShowId;
entity.UnavailableSeats = layout.UnavailableSeats;
return(entity);
}
public FeedbackEntity SearchFeedbackDAL(int feedbackId)
{
var ObjContext = new CinestarEntitiesDAL();
var objFeedback = ObjContext.Feedbacks.Find(feedbackId);
FeedbackEntity feedback = new FeedbackEntity();
if (objFeedback != null)
{
feedback.FeedbackId = objFeedback.FeedbackId;
feedback.FeedbackDetails = objFeedback.FeedbackDetails;
feedback.ViewersId = objFeedback.ViewersId;
}
return(feedback);
}
public List <LanguageEntity> ViewAllLanguageDAL()
{
List <LanguageEntity> objGenreList = new List <LanguageEntity>();
var objcontext = new CinestarEntitiesDAL();
var query = from s in objcontext.Languages
select s;
LanguageEntity objGenre = null;
foreach (var newGenre in query)
{
objGenre = new LanguageEntity();
objGenre.LanguageId = newGenre.LanguageId;
objGenre.LanguageName = newGenre.LanguageName;
objGenreList.Add(objGenre);
}
return(objGenreList);
}
public bool DeleteMovieDAL(int movieId)
{
bool isDeleted = false;
var objContext = new CinestarEntitiesDAL();
var objMovie = objContext.Movies.Find(movieId);
if (objMovie != null)
{
objContext.Movies.Remove(objMovie);
int NoofRowsAffected = objContext.SaveChanges();
isDeleted = (NoofRowsAffected > 0);
}
else
{
isDeleted = false;
}
return(isDeleted);
}
public List <ScreenEntity> ViewAllScreenDAL()
{
List <ScreenEntity> ObjLanguageList = new List <ScreenEntity>();
var objcontext = new CinestarEntitiesDAL();
var query = from s in objcontext.Screens
select s;
ScreenEntity objLanguageL = null;
foreach (var newGenre in query)
{
objLanguageL = new ScreenEntity();
objLanguageL.ScreenId = newGenre.ScreenId;
objLanguageL.ScreenName = newGenre.ScreenName;
ObjLanguageList.Add(objLanguageL);
}
return(ObjLanguageList);
}
public static MovyEntity SearchMovieByIdDAL(int id)
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var movieQuery = from item in ObjContext.Movies
where item.MovieId == id
select item;
Movy movie = ObjContext.Movies.Find(id);
MovyEntity entity = new MovyEntity();
entity.GenreId = movie.GenreId;
entity.LanguageId = movie.LanguageId;
entity.MovieDescription = movie.MovieDescription;
entity.MovieId = movie.MovieId;
entity.MovieName = movie.MovieName;
entity.MovieUrl = movie.MovieUrl;
entity.ReleaseDate = movie.ReleaseDate;
return(entity);
}
public static TicketEntity SearchTicketById(int id)
{
TicketEntity objTicket = new TicketEntity();
var objcontext = new CinestarEntitiesDAL();
Ticket ticket = objcontext.Tickets.Find(id);
objTicket.MovieId = ticket.MovieId;
objTicket.Price = ticket.Price;
objTicket.NoOfTickets = ticket.NoOfTickets;
objTicket.ShowId = ticket.ShowId;
objTicket.Ticketid = ticket.Ticketid;
objTicket.TransactionDate = ticket.TransactionDate;
objTicket.ViewersId = ticket.ViewersId;
objTicket.Seats = ticket.Seats;
return(objTicket);;
}
public bool UpdateMovieDAL(MovyEntity updateMovie)
{
bool movieUpdated = false;
var ObjContext = new CinestarEntitiesDAL();
var objMovie = ObjContext.Movies.Find(updateMovie.MovieId);
if (objMovie != null)
{
objMovie.MovieId = updateMovie.MovieId;
objMovie.MovieName = updateMovie.MovieName;
objMovie.MovieUrl = updateMovie.MovieUrl;
objMovie.ReleaseDate = updateMovie.ReleaseDate;
objMovie.GenreId = updateMovie.GenreId;
objMovie.LanguageId = updateMovie.LanguageId;
objMovie.MovieDescription = updateMovie.MovieDescription;
int NoofRowsAffected = ObjContext.SaveChanges();
movieUpdated = (NoofRowsAffected > 0);
}
return(movieUpdated);
}
public static bool UpdateLayoutDAL(ShowSeatLayoutEntity layout)
{
CinestarEntitiesDAL cinestar = new CinestarEntitiesDAL();
ShowSeatLayout seatLayout = new ShowSeatLayout();
seatLayout.LayoutId = layout.LayoutId;
seatLayout.ShowId = layout.ShowId;
seatLayout.UnavailableSeats = layout.UnavailableSeats;
cinestar.Entry(seatLayout).State = EntityState.Modified;
int rowsaffected = cinestar.SaveChanges();
if (rowsaffected > 0)
{
return(true);
}
else
{
return(false);
}
}
public static ScreenEntity SearchScreenByIdDAL(int id)
{
ScreenEntity searchScreen = new ScreenEntity();
try
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjScreen = ObjContext.Screens.Find(id);
if (ObjScreen != null)
{
searchScreen.ScreenId = ObjScreen.ScreenId;
searchScreen.ScreenName = ObjScreen.ScreenName;
}
}
catch (Exception ex)
{
throw new MovieExceptions("Error : Reading searching data", ex);
}
return(searchScreen);
}
public bool LoginUserDAL(UserEntity userlogin)
{
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
User test = ObjContext.Users.Find(userlogin.UserName);
if (test != null)
{
if (test.UserName.Equals(userlogin.UserName) && test.Password.Equals(userlogin.Password))
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public List <MovyEntityNew> GetAllMoviesDAL()
{
List <MovyEntityNew> result = new List <MovyEntityNew>();
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjMovieList = from Movie in ObjContext.Movies
join Genre in ObjContext.Genres
on Movie.GenreId equals Genre.GenreId
join Language in ObjContext.Languages
on Movie.LanguageId equals Language.LanguageId
select new MovyEntityNew {
Genre = Genre.GenreName,
Language = Language.LanguageName,
MovieDescription = Movie.MovieDescription,
MovieId = Movie.MovieId,
MovieName = Movie.MovieName,
MovieUrl = Movie.MovieUrl,
ReleaseDate = Movie.ReleaseDate
};
foreach (var item in ObjMovieList)
{
MovyEntityNew entity = new MovyEntityNew();
entity.Genre = item.Genre;
entity.Language = item.Language;
entity.MovieDescription = item.MovieDescription;
entity.MovieId = item.MovieId;
entity.MovieName = item.MovieName;
entity.MovieUrl = item.MovieUrl;
entity.ReleaseDate = item.ReleaseDate;
result.Add(entity);
}
return(result);
}