public ActionResult Edit([Bind(Include = "ID_ResultSet,ID_Object,ResultSetName")] Tb_ResultSets tb_ResultSets, int idObject, int idContext, int idProject)
{
if (ModelState.IsValid)
{
db.Entry(tb_ResultSets).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { idContext = idContext, idObject = idObject, idProject = idProject }));
}
ViewBag.ID_Object = new SelectList(db.Tb_Objects, "ID_Object", "ObjectName", tb_ResultSets.ID_Object);
return(View(tb_ResultSets));
}
public void GetResultSet(string SP_name, string ConnStr, int idObject)
{
// obtener mediante idObj la lista de parametros
//convertir a sql parameters: valores dummies (decimal p/e: 0.0)
List <Tb_Parameters> parameters;
List <SqlParameter> queryParams = new List <SqlParameter>();
parameters = db.Tb_Parameters.Where(x => x.ID_Object == idObject).ToList();
foreach (var item in parameters)
{
queryParams.Add(new SqlParameter(item.ParameterName, item.DataType));
}
int consecutiveNumbr = 1;
DataSet DS = DataAccessADO.GetDataSet(SP_name, CommandType.StoredProcedure, queryParams, ConnStr, null); // tercer paso
//List<Tb_ResultSets> RS = new List<Tb_ResultSets>();
List <Tb_ResultSetColumns> RSC = new List <Tb_ResultSetColumns>();
foreach (DataTable resultSet in DS.Tables) // itero de DS casa DT
{
Tb_ResultSets tbResult = new Tb_ResultSets();
tbResult.ID_Object = idObject;
tbResult.ResultSetName = "SET " + consecutiveNumbr;
//RS.Add(tbResult);
db.Tb_ResultSets.Add(tbResult);
db.SaveChanges();
foreach (DataColumn column in resultSet.Columns) // decada DT, itero cada DC
{
Tb_ResultSetColumns tbColumn = new Tb_ResultSetColumns();
tbColumn.ID_ResultSet = tbResult.ID_ResultSet;
tbColumn.ParameterName = column.ColumnName;
tbColumn.DataType = column.DataType.Name;
tbColumn.Length = column.MaxLength;
tbColumn.Nullable = column.AllowDBNull;
tbColumn.IsOut = false;
tbColumn.Presition = 0;
RSC.Add(tbColumn);
}
consecutiveNumbr++;
}
//db.Tb_ResultSets.AddRange(RS); // almaceno los Result Sets
//db.SaveChanges();
db.Tb_ResultSetColumns.AddRange(RSC); // almaceno los Result Set Columns
db.SaveChanges();
}
// GET: ResultSets/Edit/5
public ActionResult Edit(int?id, int idObject, int idContext, int idProject)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tb_ResultSets tb_ResultSets = db.Tb_ResultSets.Find(id);
if (tb_ResultSets == null)
{
return(HttpNotFound());
}
ViewBag.idObject = idObject;
ViewBag.idContext = idContext;
ViewBag.objName = db.Tb_Objects.Where(x => x.ID_Object == idObject).Select(x => x.ObjectName).FirstOrDefault();
ViewBag.ID_Object = new SelectList(db.Tb_Objects, "ID_Object", "ObjectName", tb_ResultSets.ID_Object);
return(View(tb_ResultSets));
}
