// 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));
}
