public List <DropdownListViewModel> ddlSourceData() { List <DropdownListViewModel> ListData = new List <DropdownListViewModel>(); var connectionString = context.Database.GetDbConnection().ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { //Declare COnnection var querySstring = "spMKT_POLO_DDL_SOURCE_DATA"; SqlCommand command = new SqlCommand(querySstring, connection); //open Connection command.Connection.Open(); //PRoses Sp SqlDataReader rd = command.ExecuteReader(); while (rd.Read()) { DropdownListViewModel data = new DropdownListViewModel(); data.Text = rd[0].ToString(); data.Value = rd[1].ToString(); data.Filter = rd[2].ToString(); data.Filter2 = rd[3].ToString(); ListData.Add(data); } //Connection Close command.Connection.Close(); } return(ListData); }
public List <DropdownListViewModel> ddlPriorityLevel(string source, string emp, string prospec) { List <DropdownListViewModel> ListData = new List <DropdownListViewModel>(); var connectionString = context.Database.GetDbConnection().ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { //Declare COnnection var querySstring = "spMKT_POLO_DDL_PRIORITY_LVL"; //Define Query Parameter SqlCommand command = new SqlCommand(querySstring, connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@pSource", source); command.Parameters.AddWithValue("@pEmp", emp); command.Parameters.AddWithValue("@pProspec", prospec); //open Connection command.Connection.Open(); //PRoses Sp SqlDataReader rd = command.ExecuteReader(); while (rd.Read()) { DropdownListViewModel data = new DropdownListViewModel(); data.Text = rd[0].ToString(); data.Value = rd[1].ToString(); data.Filter = rd[2].ToString(); data.Filter2 = rd[3].ToString(); data.Filter3 = rd[4].ToString(); ListData.Add(data); } //Connection Close command.Connection.Close(); } return(ListData); }
public void OnGet() { // fake Drivers from DB var Drivers = new Driver[] { new Driver() { ID = "id1", FullName = "name1" }, new Driver() { ID = "id2", FullName = "name2" }, new Driver() { ID = "id3", FullName = "name3" }, new Driver() { ID = "id4", FullName = "name4" }, new Driver() { ID = "id5", FullName = "name5" }, }; DriverList = Drivers.Select(a => new SelectListItem { Value = a.ID.ToString(), Text = a.FullName, //Selected = false, }).ToList(); DropdownListViewModel = new DropdownListViewModel(); DropdownListViewModel.Drivers = DriverList; }