Initial View before entering anything
when user start typing movie Name following output come
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjUxRfMxU3Lm3I8itN6BUjMQY8V1pAnfXNRlWW2BWjBDq99VX7kILxFCyhyIMVBcTouDppLKietmITBcfe2TkVI39ArfWABs0M63gVYEjDanBe8D5Mqe35RqiuWmXdfjBlreLG9KAiEAU/s1600/msg+box.png)
/*Ajax call which fill Drop-down list with the movies whose name start with the characters entered in the TextBox*/
$('#filmName').autocomplete({
source: function (request, response) {
$.ajax({
url:'@Url.Action("GetMovies","Agreement")',
data: { query: request.term },
dataType: 'json',
type: 'GET',
async: false,
success: function (movies) {
$("#selectMovie").empty();
for (var i = 0; i < 1; i++) {
for (var j = 0; j < movies[i].Id.length; j++) {
$("#selectMovie").append("<option value=" + movies[i].Id[j] + ">" + movies[i].name[j] + "</option>");
}
source: function (request, response) {
$.ajax({
url:'@Url.Action("GetMovies","Agreement")',
data: { query: request.term },
dataType: 'json',
type: 'GET',
async: false,
success: function (movies) {
$("#selectMovie").empty();
for (var i = 0; i < 1; i++) {
for (var j = 0; j < movies[i].Id.length; j++) {
$("#selectMovie").append("<option value=" + movies[i].Id[j] + ">" + movies[i].name[j] + "</option>");
}
}
}
})
},
minLength: 1
});
}
})
},
minLength: 1
});
/*Controller action which retrive moviesName with comma separated StarCast and Id of movie */
/*Ajax call to Get movies to show into dropdown list depending on textbox value for EditAppend*/
public JsonResult GetMovies(string query)
{
AMSEntities db = new AMSEntities();
List<AMSProgram> pgm;
pgm = db.AMSPrograms.Where(x => x.ProgramName.StartsWith(query)).ToList();
public JsonResult GetMovies(string query)
{
AMSEntities db = new AMSEntities();
List<AMSProgram> pgm;
pgm = db.AMSPrograms.Where(x => x.ProgramName.StartsWith(query)).ToList();
var movies = new List<string>();
var moviesId = new List<long>();
var moviesId = new List<long>();
int starId;
foreach (var program in pgm)
{
long pgmId = program.ProgramId;
string pgmName = program.ProgramName;
string filmCrew = context.AMSPrograms.Where(x => x.ProgramId == pgmId).Select(y => y.StarCasts).FirstOrDefault();
foreach (var program in pgm)
{
long pgmId = program.ProgramId;
string pgmName = program.ProgramName;
string filmCrew = context.AMSPrograms.Where(x => x.ProgramId == pgmId).Select(y => y.StarCasts).FirstOrDefault();
string starcast = filmCrew.ToString();
string[] actors = starcast.Split(',');
string allActors = pgmName + "[";
string[] actors = starcast.Split(',');
string allActors = pgmName + "[";
for (int i = 0; i < actors.Length - 1; i++)
{
if (actors[i] != "")
{
starId = Convert.ToInt32(actors[i]);
string actorName = context.AMSFilmStars.Where(x => x.FilmStarId == starId).Select(y => y.Name).FirstOrDefault().ToString();
allActors += actorName + ",";
}
}
allActors = allActors + "]";
movies.Add(allActors);
moviesId.Add(pgmId);
{
if (actors[i] != "")
{
starId = Convert.ToInt32(actors[i]);
string actorName = context.AMSFilmStars.Where(x => x.FilmStarId == starId).Select(y => y.Name).FirstOrDefault().ToString();
allActors += actorName + ",";
}
}
allActors = allActors + "]";
movies.Add(allActors);
moviesId.Add(pgmId);
}
var result = (from x in pgm select new { name = movies, Id = moviesId });
return Json(result, JsonRequestBehavior.AllowGet);
}
var result = (from x in pgm select new { name = movies, Id = moviesId });
return Json(result, JsonRequestBehavior.AllowGet);
}
No comments:
Post a Comment