public void bindTraingtype() { DataSet ds = null; Trainingmaster master = new Trainingmaster(); master.Action = "Select"; ds = master.FTrainingmaster(master); ViewBag.data = ds.Tables[0]; List<SelectListItem> items = new List<SelectListItem>(); items.Add(new SelectListItem { Text = "Select", Value = "0" }); foreach (System.Data.DataRow dr in ViewBag.data.Rows) { items.Add(new SelectListItem { Text = @dr["Name"].ToString(), Value = @dr["Id"].ToString() }); } ViewData["Type"] = items; }
public ActionResult Index(Trainingmaster model, string submit) { if (submit == "Submit" || submit == null) { master.Action = "Insert"; master.Name = model.Name; DataSet ds = master.FTrainingmaster(master); TempData["message"] = ds.Tables[0].Rows[0][0].ToString(); } else { master.Action = "Update"; master.T_Id = model.T_Id; master.Name = model.Name; DataSet ds = master.FTrainingmaster(master); TempData["message"] = ds.Tables[0].Rows[0][0].ToString(); } return RedirectToAction("Index", "Trainingmaster"); }
public DataSet FTrainingmaster(Trainingmaster obj) { DataSet ds = null; try { #region Parameters string[,] str = new string[4, 2]; str[0, 0] = "@Action"; str[0, 1] = obj.Action; str[1, 0] = "@Tid"; str[1, 1] = obj.T_Id.ToString(); str[2, 0] = "@Name"; if (obj.Name == null) { str[2, 1] = ""; } else { str[2, 1] = obj.Name; } str[3, 0] = "@Active"; str[3, 1] = obj.Active.ToString(); #endregion Database db = new Database(); ds = db.StoreprocedureExecuteDsReturned("[SP_HSRS_Training_Masters]", str); return ds; } catch (Exception) { throw; } }
public void trainigdata() { DataSet ds = null; Trainingmaster Trainig = new Trainingmaster(); Trainig.Action = "Select"; ds = Trainig.FTrainingmaster(Trainig); ViewData["AllcouData"] = ds.Tables[0]; }