public IHttpActionResult PutMOVIE(int id, MOVIE mOVIE)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != mOVIE.MovieID)
{
return(BadRequest());
}
db.Entry(mOVIE).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MOVIEExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public AddEdit_MovieForm(MOVIE obj, int MID)
{
InitializeComponent();
if (obj == null)
{
mOVIEBindingSource.DataSource = new MOVIE();
}
else
{
mOVIEBindingSource.DataSource = obj;
model = obj;
model.MID = MID;
model = db.Movies.Where(x => x.MID == obj.MID).FirstOrDefault();
textBoxName.Text = obj.Name;
textBoxDirector.Text = obj.Director;
textBoxCast.Text = obj.Cast;
textBoxGenre.Text = obj.Genre;
textBoxRating.Text = obj.Rating.ToString();
pictureBox.Image = ConvertBinaryToImage(obj.Poster);
buttonSave.Text = "Update";
}
}
public ActionResult MovieName()
{
//MOVIE mv= new MOVIE() { name="Gangleader"};
// return View(mv);
CustomerMovieViewModel viewModel = new CustomerMovieViewModel();
MOVIE m1 = new MOVIE()
{
Moviename = "GangLeader"
};
List <Customer> Customers = new List <Customer>
{
new Customer {
Customername = "Rama"
},
new Customer {
Customername = "Thanmayi"
},
new Customer {
Customername = "Suchi"
},
new Customer {
Customername = "Mouni"
},
new Customer {
Customername = "Vaishu"
},
};
viewModel.Movie = m1;
viewModel.Customers = Customers;
return(View(viewModel));
}
protected void Button1_Click(object sender, EventArgs e)
{
string movName = txtMovie.Text;
string sesName = txtSession.Text;
int sesDuration = Convert.ToInt32(txtDuration.Text);
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
MOVIE d = new MOVIE();
MOVIE existingMovie = (from x in db.MOVIEs where x.Name == movName && x.Session_1 == sesName && x.Duration == sesDuration && x.Approve == true select x).SingleOrDefault();
if (existingMovie == null)
{
d.Name = movName;
d.Session_1 = sesName;
d.Duration = sesDuration;
d.Approve = true;
db.MOVIEs.InsertOnSubmit(d);
db.SubmitChanges();
lblMsg.Visible = true;
lblMsg.Text = "Movie Has Added Successfully";
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Movie Already Exist";
txtMovie.Text = "";
}
Session["MovieName"] = txtMovie.Text;
Session["Sesname"] = txtSession.Text;
Session["Duration"] = txtDuration.Text;
}
int userID = 1;//用户ID整个会话都要保存，默认没有登录，即为-1
//public bool isLatest;//是否显示最新评论
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Form["movieName"] != null)
{
string message = Request.Form["movieName"];
//Response.Write(message);
Session["MovieNameToMovieDetails"] = message;
}
}
movieName = Convert.ToString(Session["MovieNameToMovieDetails"]);
Session["MovieOnShow"] = movieName;
//*******************************************************************************
//注意，一定要将这两个量写在if判断的外面，否则每次点击按钮后变16-17行设置的默认值
//movieName=Session["MovieName"];
//userID=Session["UserID"];
//*******************************************************************************
if (!IsPostBack)
{
//HyperLinkBack.NavigateUrl = "~/Main.aspx";
//得到前页面的电影名
//movieName = Convert.ToString(Session["MovieNameToDetail"]);
//将电影名绑定到控件
LabelMovieName.Text = movieName;
//根据电影名得到电影对象，从而获取电影详细信息
MOVIE movie = movieBll.GetMovie(movieName);
LabelRank.Text = movie.rank.ToString() + "分";
LabelRankNum.Text = "已有" + movie.rank_number.ToString() + "人打分";
//跳转到buy_list
//HyperLinkBuy.NavigateUrl = "~/";
//根据电影名得到电影海报的路径
// ImageMapMovie.ImageUrl = movieBll.GetPicture(movieName);
string moviePicture = string.Empty;
moviePicture = movieBll.GetMoviePicture(movieName);
//绑定电影图片到控件
ImageMovieDetail.ImageUrl = moviePicture;
//根据电影名 得到电影的详细信息
LabelMovieDetails.Text = movie.introduction;
//根据电影院名得到电影院最新评论列表,默认显示最新列表
//isLatest = true;
List <Comment> comment = movieBll.GetLatestComments(movieName);
//CommentGridView.DataSource = comment;
//CommentGridView.DataBind();
DisplayMovieComment(comment);
//设置返回前页链接
}
}
public ActionResult DeleteCustomerDetails(MOVIE movieFromView)
{
var movieInDB = dbContext.Movies.FirstOrDefault(c => c.id == movieFromView.id);
dbContext.Movies.Remove(movieInDB);
dbContext.SaveChanges();
return(RedirectToAction("MovieIndexs", "Movies"));
}
public void finshSearch(MOVIE movie, List <Cinema> cinemas)
{
string innerHtml = "";
Response.Write(innerHtml);
}
public ActionResult DeleteConfirmed(int id)
{
MOVIE mOVIE = db.MOVIEs.Find(id);
db.MOVIEs.Remove(mOVIE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Createm()
{
var movie = new MOVIE();
ViewBag.GenreId = ListGenre();
return(View(movie));
}
public ActionResult Edit([Bind(Include = "ID_MOVIE,NAME,TIME,TYPE,IMAGE")] MOVIE mOVIE)
{
if (ModelState.IsValid)
{
db.Entry(mOVIE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mOVIE));
}
public void dealTheSearch(MOVIE movie, List <MOVIE_SCHEDULE> newMovieSchedule)
{
List <Cinema> cinemas = new List <Cinema>();
Cinema cinema = new Cinema();
CinemaBLL cinemaBll = new CinemaBLL();
int first = 0;
int add = 0;
//找出电影院
foreach (MOVIE_SCHEDULE ms in newMovieSchedule)
{
CINEMA cia = cinemaBll.GetCinemaById(ms.cinema_id.Value);
cinema.CinemaName = cia.name;
cinema.CinemaId = ms.cinema_id.Value;
//cinema._cinemaMovieSchedule.Add(ms);
if (first == 0)
{
first = -1;
cinemas.Add(cinema);
}
else
{
foreach (Cinema ca in cinemas)
{
if (ca.CinemaId == ms.cinema_id)
{
add = 1;
break;
}
}
if (add != 1)
{
cinemas.Add(cinema);
}
}
add = 0;
}
//找出电影院中播放的电影时刻表
foreach (Cinema cima in cinemas)
{
foreach (MOVIE_SCHEDULE mese in newMovieSchedule)
{
if (cima.CinemaId == mese.cinema_id)
{
cima._cinemaMovieSchedule.Add(mese);
}
}
}
//////////////////
finshSearch(movie, cinemas);
}
public ActionResult Create([Bind(Include = "ID_MOVIE,NAME,TIME,TYPE,IMAGE")] MOVIE mOVIE)
{
if (ModelState.IsValid)
{
db.MOVIEs.Add(mOVIE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mOVIE));
}
public ActionResult Createm(MOVIE movieFromView)
{
if (!ModelState.IsValid)
{
ViewBag.GenreId = ListGenre();
return(View(movieFromView));
}
dbContext.Movies.Add(movieFromView);
dbContext.SaveChanges();
return(RedirectToAction("MovieIndexs", "Movies"));
}
public ActionResult Create([Bind(Include = "ID,TITLE,RELEASE")] MOVIE mOVIE)
{
if (ModelState.IsValid)
{
db.MOVIE.Add(mOVIE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mOVIE));
}
public IHttpActionResult GetMOVIE(int id)
{
MOVIE mOVIE = db.MOVIEs.Find(id);
if (mOVIE == null)
{
return(NotFound());
}
return(Ok(mOVIE));
}
private void comboBoxMovieName_SelectionChangeCommitted(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
MOVIE obj = comboBoxMovieName.SelectedItem as MOVIE;
if (obj != null)
{
textBoxMovieID.Text = obj.MovieID.ToString();
textBoxMovieName.Text = obj.Name.ToString();
}
Cursor.Current = Cursors.Default;
}
/* private void savepic()
* {
*
* using (DBEntities db = new DBEntities())
* {
* MOVIE mv = new MOVIE() { Poster = ConvertImageToBinary(pictureBox.Image) };
* db.Movies.Add(mv);
* db.SaveChanges();
* MessageBox.Show("You have submitted the picture ");
*
*
*
* }
*
*
* }*/
private void buttonSave_Click(object sender, EventArgs e)
{
if (buttonSave.Text == "Save")
{
try
{
model.Name = textBoxName.Text.Trim();
model.Director = textBoxDirector.Text.Trim();
model.Cast = textBoxCast.Text.Trim();
model.Genre = textBoxGenre.Text.Trim();
model.Rating = Convert.ToDecimal(textBoxRating.Text.Trim());
model.Poster = ConvertImageToBinary(pictureBox.Image);
using (DBEntities db = new DBEntities())
{
db.Movies.Add(model);
db.SaveChanges();
}
MessageBox.Show("Your Movie details are submitted");
}
catch (Exception er)
{
MessageBox.Show(er.ToString());
}
}
else
{
try
{
model = db.Movies.Where(x => x.MID == model.MID).FirstOrDefault();
model.Name = textBoxName.Text.Trim();
model.Director = textBoxDirector.Text.Trim();
model.Cast = textBoxCast.Text.Trim();
model.Genre = textBoxGenre.Text.Trim();
model.Rating = Convert.ToDecimal(textBoxRating.Text.Trim());
model.Poster = ConvertImageToBinary(pictureBox.Image);
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Your Movie details are Updated");
}
catch (Exception ep)
{
MessageBox.Show(ep.ToString());
}
}
}
public IHttpActionResult PostMOVIE(MOVIE mOVIE)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.MOVIEs.Add(mOVIE);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = mOVIE.MovieID }, mOVIE));
}
public IHttpActionResult DeleteMOVIE(int id)
{
MOVIE mOVIE = db.MOVIEs.Find(id);
if (mOVIE == null)
{
return(NotFound());
}
db.MOVIEs.Remove(mOVIE);
db.SaveChanges();
return(Ok(mOVIE));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MOVIE mOVIE = db.MOVIEs.Find(id);
if (mOVIE == null)
{
return(HttpNotFound());
}
return(View(mOVIE));
}
public MOVIE SearchMovie(string newMovieName)
{
//根据电影名返回电影对象
WATCHMOVIEEntities w = new WATCHMOVIEEntities();
MOVIE movie = new MOVIE();
var result = from m in w.MOVIE
where m.name.Equals(newMovieName)
select m;
if (result.Count() > 0)
{
movie = result.First();
}
return(movie);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlSession.Items.Add("Select a session");
DataClassesDataContext db = new DataClassesDataContext();
string movie = Session["Movie"].ToString();
MOVIE sessionList = (from x in db.MOVIEs where x.MovieName == movie select x).SingleOrDefault();
ddlSession.Items.Add(sessionList.Session1);
ddlSession.Items.Add(sessionList.Session2);
ddlSession.Items.Add(sessionList.Session3);
}
}
protected void Page_Load(object sender, EventArgs e)
{
movieName = (string)Session["MovieNameToMovieComment"];
userID = (int)Session["UserID"];
if (!IsPostBack)
{
LabelMovieName.Text = movieName;
MOVIE movie = movieBll.GetMovie(movieName);
LabelRank.Text = movie.rank.ToString() + "分";
LabelRankNum.Text = "已有" + movie.rank_number.ToString() + "人打分";
string moviePicture = string.Empty;
moviePicture = movieBll.GetMoviePicture(movieName);
//绑定电影图片到控件
ImageMovieDetail.ImageUrl = moviePicture;
LabelMovieDetails.Text = movie.introduction;
}
}
public ActionResult EditMovieDetails(MOVIE movieFromView)
{
if (ModelState.IsValid)
{
//ViewBag.GenreId = ListGenre();
var movieInDB = dbContext.Movies.FirstOrDefault(c => c.id == movieFromView.id);
movieInDB.Moviename = movieFromView.Moviename;
movieInDB.ReleaseDate = movieFromView.ReleaseDate;
movieInDB.DateAdded = movieFromView.DateAdded;
movieInDB.GenreId = movieFromView.GenreId;
movieInDB.AvailableStock = movieFromView.AvailableStock;
dbContext.SaveChanges();
return(RedirectToAction("MovieIndexs", "Movies"));
}
else
{
ViewBag.GenreId = ListGenre();
return(View(movieFromView));
}
}
/* public bool AddMovie(string name,string director,string actor,string kind,string region
* ,int lastingTime,DateTime firstShowTime,string introduction,Byte rank,int rankNum,
* int clickNum,bool onShow)
* {//向数据库电影表MOVIEs中插入一个电影记录
*
* WATCHMOVIEEntities entity = new WATCHMOVIEEntities();
* MOVIE newMovie = new MOVIE();
* newMovie.name = name;
* newMovie.director = director;
* newMovie.actor = actor;
* newMovie.kind = kind;
* newMovie.region = region;
* newMovie.last_time = lastingTime;
* newMovie.first_showtime = firstShowTime;
* newMovie.introduction = introduction;
* newMovie.rank = rank;
* newMovie.rank_number = rankNum;
* newMovie.click_number = clickNum;
* newMovie.is_on_show = onShow;//给新对象添加属性；
*
* entity.MOVIE.AddObject(newMovie);
* int i=0;
* try
* {
* i = entity.SaveChanges();
* }
* catch (Exception exp)
* {
* MessageBox.Show (exp.ToString());
* entity.Dispose();//销毁对象
* return false;
* }
* entity.Dispose();//销毁对象
* return true;
*
* }
*/
public bool AddMovie(string name, string director, string actor, string kind, string region
, int lastingTime, DateTime firstShowTime, string introduction, Byte rank, int rankNum,
int clickNum)
{//向数据库电影表MOVIEs中插入一个电影记录
WATCHMOVIEEntities entity = new WATCHMOVIEEntities();
MOVIE newMovie = new MOVIE();
//给新对象添加属性；
newMovie.name = name;
newMovie.director = director;
newMovie.actor = actor;
newMovie.kind = kind;
newMovie.region = region;
//newMovie.last_time = lastingTime; //7.22 cm
newMovie.last_time = (short)lastingTime;
newMovie.first_showtime = firstShowTime;
newMovie.introduction = introduction;
newMovie.rank = rank;
//newMovie.rank_number = rankNum; //7.22 cm
newMovie.rank_number = (short)rankNum;
//newMovie.click_number = clickNum; //7.22 cm
newMovie.click_number = (short)clickNum;
entity.MOVIE.AddObject(newMovie);
int i = 0;
try
{
i = entity.SaveChanges();
}
catch (Exception exp)
{
//MessageBox.Show(exp.ToString());
entity.Dispose();//销毁对象
return(false);
}
entity.Dispose();//销毁对象
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
// selectHotPlayMovies();
string message = Request.Form["selectType"];
//MessageBox.Show(message);
if (message == "playType")
{
message = Request.Form["message"];
if (message == "热映中")
{
message = "onshow";
}
else if (message == "即将上映")
{
message = "willshow";
}
else
{
message = "";
}
SearchOnshowMovie(message);
}
else if (message == "region")
{
message = Request.Form["value"];
SearchByRegion(message);
}
else if (message == "load")
{
if (Request.Cookies["UserEmail"] != null)
{
//默认登录用户的初始化
selectRecommend();
}
else
{
//未登录时的初始化
selectHotPlayMovies();
}
}
else if (message == "hot")
{
selectHotPlayMovies();
}
else if (message == "rank")
{
selectRankHighMovies();
}
else if (message == "recommend")
{
selectRecommend();
}
else if (message == "playAddr")
{
string region = Request.Form["addr"];
SearchByRegion(region);
}
else if (message == "searchmovie")
{
message = Request.Form["movieName"];
//获取电影院
MOVIE movie = new MOVIE();
movie = new MoviesBLL().GetMovie(message);
//List<List<MOVIE_SCHEDULE>> schedulelist = new List<List<MOVIE_SCHEDULE>>();
List <MOVIE_SCHEDULE> allMovieSchedule = new List <MOVIE_SCHEDULE>();
allMovieSchedule = new MoviesBLL().GetAllMovieSchedule(movie.id);
//添加处理函数
dealTheSearch(movie, allMovieSchedule);
}
else
{
// MessageBox.Show(message);
}
}
public void dealSelect(List <MOVIE> movies)
{
//处理选择信息 传入一个电影列表
int pageTotal = movies.Count();
//MessageBox.Show(pageTotal.ToString());
int pageNum = 0;
int pageAdd = 0;
int currentMovie = 0;
if (movies.Count() > 9)
{
pageNum = (movies.Count() - 9) / 12;
pageAdd = (movies.Count() - 9) % 12;
if (pageAdd > 0)
{
pageNum += 2;
}
else
{
pageNum++;
}
}
else
{
pageNum = 1;
}
// MessageBox.Show(pageNum.ToString());
string innerHtml = "<div id='test'><div class='slides_container'>";
// DateTime time=DateTime.Now.Date;
for (int i = 0; i < pageNum; i++)
{
if (i == 0)
{
innerHtml += "<div class='boxb_2'> ";
MOVIE movie = movies.First();
innerHtml += formBigHtml(movie.name, movie.rank.Value, movie.director, movie.actor, movie.kind
, movie.region, movie.first_showtime.Value, movie.last_time.Value, movie.path);//第一张大图
pageTotal--;
currentMovie++;
if (pageTotal == 0)
{
break;
}
// MessageBox.Show(innerHtml + "1");
for (int j = 0; j < 8; j++)
{
movie = movies.ElementAt(currentMovie);
innerHtml += formSmalHtml(movie.name, movie.rank.Value, movie.kind
, movie.region, movie.first_showtime.Value, movie.path);
pageTotal--;
currentMovie++;
//MessageBox.Show(innerHtml + " "+pageTotal.ToString());
if (pageTotal == 0)
{
break;
}
}
innerHtml += "</div>";
//MessageBox.Show(innerHtml);
}
else
{
currentMovie = 9 + 12 * (i - 1);
innerHtml += "<div class='boxb_2'>";
for (int j = 0; j < 12; j++)
{
MOVIE movie = movies.ElementAt(currentMovie);
innerHtml += formSmalHtml(movie.name, movie.rank.Value, movie.kind
, movie.region, movie.first_showtime.Value, movie.path);
pageTotal--;
currentMovie++;
if (pageTotal == 0)
{
break;
}
}
// <div class='mainPhoto'>
//</div>
innerHtml += "</div>";
}
if (pageTotal == 0)
{
break;
}
else
{
continue;
}
}
innerHtml += "</div>" + formPagePoint(pageNum);
Response.Write(innerHtml + "</div></div>");
}
partial void DeleteMOVIE(MOVIE instance);
partial void UpdateMOVIE(MOVIE instance);
partial void InsertMOVIE(MOVIE instance);
