public static DbSet GetTableData(string tablename) { var mType = BuildManager.GetType(string.Format("TFATERPWebApplication.Dal.{0}", tablename), true); TFAT_WEBERPEntities ctx = new TFAT_WEBERPEntities(); return(ctx.Set(mType)); }
public ActionResult NewBranch() { TFAT_WEBERPEntities ctx = new TFAT_WEBERPEntities(); List <SelectListItem> listSelectListItems = new List <SelectListItem>(); foreach (TfatPass item in ctx.TfatPasses) { SelectListItem selectlist = new SelectListItem() { Text = item.Name, Value = item.RecordKey.ToString(), Selected = item.IsSelected }; listSelectListItems.Add(selectlist); } TFatBranch u = new TFatBranch() { Users11 = listSelectListItems }; //country,state,city ViewBag.aCountry = GetOptions(); ViewBag.aState = astate; ViewBag.aCity = acity; ViewBag.CompCode = GetOptions1(); //Bussiness type var Business = new SelectList(new[] { new{ ID = "1", Name = "Traders" }, new{ ID = "2", Name = "Manufacturer" }, new{ ID = "3", Name = "name3" }, }, "ID", "Name", 1); ViewData["Business"] = Business; return(View(u)); }
public ActionResult mfgParameter() { TFAT_WEBERPEntities ctx = new TFAT_WEBERPEntities(); return(View("Index", ctx.MachineParameters.ToList())); }