public affectationTypeCompositeType GetAffectationTypeById(int iIdAffectationType) { var et = new affectationTypeCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_affectation_type", SqlDbType.Int) { Value = iIdAffectationType }; DataTable dt = objDB.ExecStore("sp_getAffectationTypeById", param); et.iIdAffectationType = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.sDescription = dt.Rows[0].ItemArray[1].ToString(); et.bStatus = bool.Parse(dt.Rows[0].ItemArray[2].ToString()); return(et); }
/// <summary> /// Obtiene todos los Tipos de Cambio /// </summary> /// <returns></returns> public List <affectationTypeCompositeType> getAll() { var lst = new List <affectationTypeCompositeType>(); DataTable dt = objDB.Consult("sp_selectAffectationType"); foreach (DataRow dr in dt.Rows) { var et = new affectationTypeCompositeType { iIdAffectationType = int.Parse(dr.ItemArray[0].ToString()), sDescription = dr.ItemArray[1].ToString(), bStatus = bool.Parse(dr.ItemArray[2].ToString()) }; lst.Add(et); } return(lst); }