public areaCompositeType GetAreaById(int iIdArea)
{
areaCompositeType et = new areaCompositeType();
param = new SqlParameter[1];
param[0] = new SqlParameter("@fiid_area", SqlDbType.Int);
param[0].Value = iIdArea;
DataTable dt = objDB.ExecStore("sp_getAreaById", param);
et.iIdArea = int.Parse(dt.Rows[0].ItemArray[0].ToString());
et.sDescription = dt.Rows[0].ItemArray[1].ToString();
et.iNumber = int.Parse(dt.Rows[0].ItemArray[2].ToString());
et.bStatus = bool.Parse(dt.Rows[0].ItemArray[3].ToString());
return(et);
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <areaCompositeType> getAll()
{
List <areaCompositeType> lst = new List <areaCompositeType>();
DataTable dt = objDB.Consult("sp_selectArea");
foreach (DataRow dr in dt.Rows)
{
areaCompositeType et = new areaCompositeType();
et.iIdArea = int.Parse(dr.ItemArray[0].ToString());
et.sDescription = dr.ItemArray[1].ToString();
et.iNumber = int.Parse(dr.ItemArray[2].ToString());
et.bStatus = bool.Parse(dr.ItemArray[3].ToString());
lst.Add(et);
}
return(lst);
}