// GET: Services/Create
public ActionResult Create()
{
//List<SelectListItem> servicetypes = (from p in
// new Models.Service().GetServiceType().ToList()
// select new SelectListItem()
// {
// Value = p.ServiceTypeId.ToString(),
// Text = p.ServiceTypeDescription
// }).ToList();
//ViewBag.ServiceTypeId = servicetypes;
//return View();
var model = new Service()
{
ServiceDescription = GetTypeOfService()
};
return View(model);
}
private IEnumerable<SelectListItem> GetTypeOfService()
{
var serviceTypes = new Service();
var roles = serviceTypes.GetServiceType()
.Select(x =>
new SelectListItem
{
Value = x.ServiceTypeId.ToString(),
Text = x.ServiceTypeDescription
});
return new SelectList(roles, "Value", "Text");
}
private string GetDescription(int? id)
{
var serviceTypes = new Service();
string type = serviceTypes.GetServiceType()
.Select(x =>
new SelectListItem
{
Value = x.ServiceTypeId.ToString(),
Text = x.ServiceTypeDescription
}).FirstOrDefault().Text;
//string query_where2 = from a in db.Services
// // where a.Name.Contains("Contoso")
// where a.ServiceId == id
// select (a.ServiceTypeId).ToString();
////string servtyp = db.Services.Select(x=>
//// new SelectListItem
//// {
//// Value = x.ServiceTypeId.ToString(),
//// Text = x.TypeOfService
//// }).Where(x=>x.Value = id)
//return query_where2.First().ToString();
string type1 = "";
var query = from c in db.Services
join a in db.ServiceTypes
on c.ServiceTypeId equals a.ServiceTypeId
where c.ServiceId == id
select new
{
type = a.ServiceTypeDescription.ToString()
};
foreach (var c in query)
{
type1 = c.type;
}
//return query.FirstOrDefault().ToString();
return type1;
}
