public IViewComponentResult Invoke()
{
var transmissions = new TransmissionModel
{
Transmissions = this.transmissionTypeService
.GetAllTypesAsync()
.Result
.OrderBy(t => t.Type)
.Select(t => new SelectListItem
{
Text = t.Type,
Value = t.Id
}).ToList()
};
return(this.View(WebConstants.ViewComponentDefault, transmissions));
}
public IEnumerable <TransmissionModel> TransmissionDropdown()
{
List <TransmissionModel> transmissions = new List <TransmissionModel>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("TransmissionDropDown", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
TransmissionModel transmission = new TransmissionModel();
transmission.TransmissionId = (int)dr["TransmissionId"];
transmission.Transmission = dr["Transmission"].ToString();
transmissions.Add(transmission);
}
}
}
return(transmissions);
}
