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];
}
