// GET: Home public ActionResult Index() { CascadingModel model = new CascadingModel(); model.Countries = PopulateDropDown("SELECT distinct CountryId, CountryName FROM Salesrep", "CountryName", "CountryId"); return(View(model)); }
public ActionResult Contact() { CascadingModel model = new CascadingModel(); model.TEAMS = PopulateDropDown("SELECT teamID, teamName FROM TEAM", "teamName", "teamID"); return(View(model)); }
//public static DataTable GetDatabaseSummary() //{ // DataTable dt = new DataTable("GoalSummary"); // //string query = "Select Vehicletype,str(count(Vehicletype)* 100.0 / (Select Count(*) From VehicleMaster), 5,1) as percentage "; // //query += "from VehicleMaster group by Vehicletype"; // string query = "SELECT COUNT(*) FROM AGOAL"; // string constr = ConfigurationManager.ConnectionStrings["Constring"].ConnectionString; // SqlConnection con = new SqlConnection(); // //con.ConnectionString = "Data Source=.;" + "Initial Catalog=Transport;" + "Persist Security Info=True;"; // SqlCommand cmd = new SqlCommand(); // cmd.CommandText = query; // cmd.Connection = con; // SqlDataAdapter da = new SqlDataAdapter(cmd); // con.Open(); // da.Fill(dt); // con.Close(); // return dt; //} //[HttpGet] //public JsonResult GoalSummary() //{ // List<ChartModel> lstSummary = new List<ChartModel>(); // foreach (DataRow dr in GetDatabaseSummary().Rows) // { // ChartModel summary = new ChartModel(); // summary.agoalID = Convert.ToInt32(dr[0]); // summary.agoalValue = Convert.ToInt32(dr[1]); // lstSummary.Add(summary); // } // return Json(lstSummary.ToList(), JsonRequestBehavior.AllowGet); //} public ActionResult Contact() { CascadingModel model = new CascadingModel(); model.TEAMS = PopulateDropDown("SELECT teamID, teamName FROM TEAM", "teamName", "teamID"); //model.WSTREAMS = GetWorkStream("INSERT INTO WSTREAM VALUES WStreamName", "TeamID", "WStreamID"); //model.CATEGORIES = GetCategories("INSERT INTO CATEGORY VALUES categName", "WStreamID", "TeamID"); return(View(model)); }
public ActionResult Index(int countryId, int stateId, int cityId) { CascadingModel model = new CascadingModel(); model.Countries = PopulateDropDown("SELECT CountryId, CountryName FROM Salesrep", "CountryName", "CountryId"); model.States = PopulateDropDown("SELECT StateId, StateName FROM Salesrep WHERE CountryId = " + countryId, "StateName", "StateId"); model.Cities = PopulateDropDown("SELECT CityId, CityName FROM Salesrep WHERE StateId = " + stateId, "CityName", "CityID"); model.Details = GetDetails("select Name,Pno from Salesrep where CountryId=" + countryId + "and StateId=" + stateId + "and CityId=" + cityId, "Name", "Pno"); return(View(model)); }
public ActionResult Contact(int teamID, int wstreamID, int categID, int subcategID) { CascadingModel model = new CascadingModel(); model.TEAMS = PopulateDropDown("SELECT teamID, teamName FROM TEAM", "teamName", "teamID"); model.WSTREAMS = PopulateDropDown("SELECT wstreamID, wstreamName FROM WSTREAM WHERE teamID = " + teamID, "wstreamName", "wstreamID"); model.CATEGORIES = PopulateDropDown("SELECT categID, categName FROM CATEGORY WHERE wstreamID = " + wstreamID, "categName", "categID"); model.SUBCATEGORIES = PopulateDropDown("SELECT subcategID, subcategName FROM SUBCATEGORY WHERE categID = " + categID, "subcategName", "subcategID"); model.AGOALS = PopulateDropDown("SELECT agoalID, agoalValue FROM AGOAL WHERE subcategID = " + subcategID, "agoalValue", "agoalID"); return(View(model)); }
// GET: Home public ActionResult Index() { CascadingModel model = new CascadingModel(); model.Countries = CreateSelectList(Countries, x => x.Id, x => x.Name); var selected = Countries.FirstOrDefault().Id; model.States = GetStatesListByCountryId(selected); model.Cities = CreateSelectList(Cities, x => x.Id, x => x.Name); return(View(model)); }
public ActionResult Index(CascadingModel model) { Thread.Sleep(2000); if (Request.IsAjaxRequest()) { Random rnd = new Random(); int randomNumber = rnd.Next(1, 4); var states = GetStatesListByCountryId(randomNumber); return(PartialView("_States", states)); } return(View(model)); }
public JsonResult AjaxMethod(string type, int value) { CascadingModel model = new CascadingModel(); switch (type) { case "CountryId": model.States = PopulateDropDown("SELECT StateId, StateName FROM Salesrep WHERE CountryId = " + value, "StateName", "StateId"); break; case "StateId": model.Cities = PopulateDropDown("SELECT CityId, CityName FROM Salesrep WHERE StateId = " + value, "CityName", "CityId"); break; } return(Json(model)); }
public JsonResult AjaxMethod(string type, int value) { CascadingModel model = new CascadingModel(); switch (type) { case "CountryId": model.States = CreateSelectList(States.Take(value).ToList(), x => x.Id, x => x.Name); break; case "StateId": model.Cities = CreateSelectList(Cities.Take(value).ToList(), x => x.Id, x => x.Name); break; } return(Json(model)); }
public JsonResult AjaxMethod(string type, int value) { CascadingModel model = new CascadingModel(); switch (type) { case "teamID": model.WSTREAMS = PopulateDropDown("SELECT wstreamID, wstreamName FROM WSTREAM WHERE teamID = " + value, "wstreamName", "wstreamID"); break; case "wstreamID": model.CATEGORIES = PopulateDropDown("SELECT categID, categName FROM CATEGORY WHERE wstreamID = " + value, "categName", "categID"); break; case "categID": model.SUBCATEGORIES = PopulateDropDown("SELECT subcategID, subcategName FROM SUBCATEGORY WHERE categID = " + value, "subcategName", "subcategID"); break; case "subcategID": model.AGOALS = PopulateDropDown("SELECT agoalID, agoalValue FROM AGOAL WHERE subcategID = " + value, "agoalValue", "agoalID"); break; } return(Json(model)); }