public SCECampana GetById(string Id)
{
SCECampana pr = new SCECampana();
try
{
DbCommand cmd;
cmd = objDBSCE.GetStoredProcCommand(EsquemaSCE + ".[PR_SCE_CAMPAÑA_SEL]");
objDBSCE.AddInParameter(cmd, "@IdCampaña", DbType.String, Id);
using (System.Data.IDataReader dataReader = objDBSCE.ExecuteReader(cmd))
{
if (dataReader.Read())
{
pr.IdCampana = dataReader["IdCampaña"].ToString();
pr.Descripcion = dataReader["DESCRIPCION"].ToString();
pr.IdCultivo = dataReader["IDCULTIVO"].ToString();
}
return(pr);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ICollection <SCECampana> Get()
{
List <SCECampana> campanas = new List <SCECampana>();
try
{
DbCommand cmd;
cmd = objDBSCE.GetStoredProcCommand(EsquemaSCE + ".[PR_SCE_CAMPAÑA_QRY]");
foreach (DataRow dr in objDBSCE.ExecuteDataSet(cmd).Tables[0].Rows)
{
SCECampana pr = new SCECampana();
pr.IdCampana = dr[0].ToString();
pr.Descripcion = dr[1].ToString();
pr.IdCultivo = dr[2].ToString();
campanas.Add(pr);
}
}
catch (Exception ex)
{
throw ex;
}
return(campanas);
}
public SCECampana Update(SCECampana entidad)
{
throw new NotImplementedException();
}
