// NOT IN USE
protected void OnItemCommand(object source, RepeaterCommandEventArgs e)
{
SPList movies = SPContext.Current.Web.Lists.TryGetList("Movies");
SPListItemCollection moviesCollection = movies.Items;
int movieItemId = int.Parse(((LinkButton)e.Item.FindControl("RemoveButton")).CommandArgument);
LinkButton click = (LinkButton)e.Item.FindControl("RemoveButton");
click.Attributes.Add("OnClick", "showDialog()");
if (e.CommandName == "delete")
{
moviesCollection.DeleteItemById(movieItemId);
}
//else if (e.CommandName == "edit")
//{
// EditIndex = e.Item.ItemIndex;
//}
//else if (e.CommandName == "save")
//{
// HtmlInputHidden t = e.Item.FindControl("firstNameHidden") as HtmlInputHidden;
// Data.Contacts[e.Item.ItemIndex].FirstName = t.Value;
// t = e.Item.FindControl("lastNameHidden") as HtmlInputHidden;
// Data.Contacts[e.Item.ItemIndex].LastName = t.Value;
// EditIndex = -1;
//}
RepeaterMovie.DataSource = moviesCollection;
RepeaterMovie.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MovieServices listmovie = new MovieServices();
MoviePeopleServices castlist = new MoviePeopleServices();
List <MovieModelDTO> ListOfAllMovies = new List <MovieModelDTO>();
ListOfAllMovies = listmovie.GetAllMovies();
ddlTitleMovie.DataSource = ListOfAllMovies;
ddlTitleMovie.DataBind();
ddlTitleMovie.Items.Insert(0, new ListItem("<-Choose Movie->", "0"));
//-------------------------------------------------------------------------
List <MovieModelDTO> ListOfYears = listmovie.GetAllYears();
List <string> Years = new List <string>();
foreach (var item in ListOfYears)
{
string year = item.Year;
Years.Add(year);
}
ddlYearMovie.DataSource = Years.ToList().Distinct();
ddlYearMovie.DataBind();
ddlYearMovie.Items.Insert(0, new ListItem("<-Choose Year->", "0"));
//-----------------------------
List <MoviePersonDTO> ListOfAcotrs = castlist.GetActors();
ddlActorMovie.DataTextField = "FirstName";
ddlActorMovie.DataValueField = "LastName";
ddlActorMovie.DataSource = ListOfAcotrs;
ddlActorMovie.DataBind();
ddlActorMovie.Items.Insert(0, new ListItem("<-Choose Actor->", "0"));
//----------------------------------------------
List <MoviePersonDTO> ListOfProducers = castlist.GetProducers();
ddlProducerMovie.DataTextField = "FirstName";
ddlProducerMovie.DataValueField = "LastName";
ddlProducerMovie.DataSource = ListOfProducers;
ddlProducerMovie.DataBind();
ddlProducerMovie.Items.Insert(0, new ListItem("<-Choose Producer->", "0"));
//-------------------------------------------------------
//genre to bind
ddlGenreMovie.DataSource = listmovie.GetAllGenres();
ddlGenreMovie.DataBind();
ddlGenreMovie.Items.Insert(0, new ListItem("<-Choose Genre->", "0"));
//repeater to bind
List <MovieModelDTO> ListOfMovies = new List <MovieModelDTO>();
ListOfMovies = listmovie.GetAllMovies();
RepeaterMovie.DataSource = ListOfMovies;
RepeaterMovie.DataBind();
}
}
private void BindRepeater()
{
SPList movies = SPContext.Current.Web.Lists.TryGetList("Movies");
SPListItemCollection moviesCollection = movies.Items;
RepeaterMovie.DataSource = moviesCollection;
RepeaterMovie.DataBind();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
SqlConnection conn2 = new SqlConnection(@"data source = LAPTOP-7ILGU10M; integrated security = true; database = MovieDB");
SqlCommand cmd2 = null;
SqlDataReader rdr2 = null;
WebClient client = new WebClient();
string result = "";
string movieselection = TextBoxSearch.Text.Replace(' ', '+');
result = client.DownloadString("http://www.omdbapi.com/?t=" + movieselection + "&r=xml&apikey=" + TokenClass.token);
string sqlsel2 = "SELECT * Id, Title, Genre, Year, Poster FROM Movies WHERE Title LIKE (@title)";
try
{
conn2.Open();
cmd2 = new SqlCommand(sqlsel2, conn2);
rdr2 = cmd2.ExecuteReader();
RepeaterMovie.DataSource = rdr2;
RepeaterMovie.DataBind();
}
catch (Exception ex)
{
// LabelMessage.Text = ex.Message;
}
finally
{
conn2.Close();
}
File.WriteAllText(Server.MapPath("~/Files/LatestResult.xml"), result);
XmlDocument doc = new XmlDocument();
doc.LoadXml(result);
if (doc.SelectSingleNode("/root/@response").InnerText == "True")
{
XmlNodeList nodelist = doc.SelectNodes("/root/movie");
foreach (XmlNode node in nodelist)
{
// string id = node.SelectSingleNode("@poster").InnerText;
// ImageDefault.ImageUrl = id;
}
LabelDirector.Text += " Director: " + nodelist[0].SelectSingleNode("@director").InnerText;
LabelActors.Text += " Actors: " + nodelist[0].SelectSingleNode("@actors").InnerText;
LabelRating.Text += " Rating: " + nodelist[0].SelectSingleNode("@imdbRating").InnerText;
LabelDescription.Text = " Description: " + nodelist[0].SelectSingleNode("@plot").InnerText;
}
else
{
LabelMessage.Text = "Movie not found";
LabelResult.Text = "";
}
}
