public plantillaeva ObtenerPlantillaByID(int evaidplantilla)
{
Datoplantillaeva DatPlant = new Datoplantillaeva();
plantillaeva plantilla = new plantillaeva();
plantilla = (from l in DatPlant.select_All_Plantilla()
where l.evaidplantilla == evaidplantilla
select l
).FirstOrDefault();
return plantilla;
// return DatAut.select_AutosbyId(IDAuto);
}
public plantillaeva select_AutosbyId(int evaidplantilla)
{
plantillaeva ObjPlantilla = new plantillaeva();
string StoredProcedure = "ObtenerPlantillaByID";
using (DbConnection con = dpf.CreateConnection())
{
con.ConnectionString = constr;
using (DbCommand cmd = dpf.CreateCommand())
{
cmd.Connection = con;
cmd.CommandText = StoredProcedure;
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param = cmd.CreateParameter();
param.DbType = DbType.Int32;
param.ParameterName = "evaidplantilla";
param.Value = evaidplantilla;
cmd.Parameters.Add(param);
con.Open();
using (DbDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
ObjPlantilla = new plantillaeva(evaidplantilla,
(string)dr["eva_nombre_plant"],
(string)dr["eva_vigencia_plant"]);
}
}
}
}
return ObjPlantilla;
}