private List <SelectListItem> GetVendorName() { MTSHRDataLayer.Vendors data_Ass = new MTSHRDataLayer.Vendors(); List <SelectListItem> Assetlist = new List <SelectListItem>(); try { var Vendor = data_Ass.ReadVendorName(); Assetlist.Add(new SelectListItem() { Value = "", Text = "---- Select Vendor Name----" }); for (int i = 0; i < Vendor.Tables[0].Rows.Count; i++) { Assetlist.Add(new SelectListItem() { Value = Vendor.Tables[0].Rows[i]["ID"].ToString(), Text = Vendor.Tables[0].Rows[i]["NAME"].ToString() }); } } catch (Exception exec) { BaseExceptionHandler.HandleException(ref exec); } return(Assetlist); }
public ActionResult Read() { MTSHRDataLayer.Vendors vendor = new MTSHRDataLayer.Vendors(); return(Json(JsonConvert.SerializeObject(vendor.ReadVendorName().Tables[0]), JsonRequestBehavior.AllowGet)); }