public ActionResult getAllServicios()
{
var lista = proxycon.GetConexionList();
List <TipServ> clasificacion = new List <TipServ>();
foreach (var item in lista)
{
ConexionController c = new ConexionController();
SqlCommand comandoSql;
int id = Int32.Parse(item.IdConexion.ToString());
SqlConnection conexionSQL2 = new SqlConnection(c.DameConexion(id));
try
{
conexionSQL2.Open();
}
catch
{ }
try
{
comandoSql = new SqlCommand("SELECT * FROM TipServ WHERE Habilitar = 0");
comandoSql.Connection = conexionSQL2;
SqlDataReader reader = comandoSql.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
TipServ datos = new TipServ();
datos.clvProblema = Int32.Parse(reader[0].ToString());
datos.descripcion = reader[1].ToString();
clasificacion.Add(datos);
}
}
}
catch { }
}
var listado = clasificacion.GroupBy(x => x.descripcion).Select(y => y.First());
return(Json(listado, JsonRequestBehavior.AllowGet));
}
public int DeleteTipServ(String BaseRemoteIp, int BaseIdUser, int?Clv_TipSer)
{
return(TipServ.Delete(Clv_TipSer));
}
public int UpdateTipServ(TipServEntity objTipServ)
{
return(TipServ.Edit(objTipServ));
}
public int AddTipServ(TipServEntity objTipServ)
{
return(TipServ.Add(objTipServ));
}
public SoftvList <TipServEntity> GetTipServPagedListXml(int page, int pageSize, String xml)
{
return(TipServ.GetPagedList(page, pageSize, xml));
}
public SoftvList <TipServEntity> GetTipServPagedList(int page, int pageSize)
{
return(TipServ.GetPagedList(page, pageSize));
}
public IEnumerable <TipServEntity> GetTipServList()
{
return(TipServ.GetAll());
}
public TipServEntity GetDeepTipServ(int?Clv_TipSer)
{
return(TipServ.GetOneDeep(Clv_TipSer));
}
public TipServEntity GetTipServ(int?Clv_TipSer)
{
return(TipServ.GetOne(Clv_TipSer));
}
