public lockingTypeCompositeType GetLockingTypeById(int iIdLockingType) { lockingTypeCompositeType et = new lockingTypeCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_locking_type", SqlDbType.Int) { Value = iIdLockingType }; DataTable dt = objDB.ExecStore("sp_getLockingTypeById", param); et.iIdLockingType = 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 <lockingTypeCompositeType> getAll() { List <lockingTypeCompositeType> lst = new List <lockingTypeCompositeType>(); DataTable dt = objDB.Consult("sp_selectLockingType"); foreach (DataRow dr in dt.Rows) { lockingTypeCompositeType et = new lockingTypeCompositeType(); et.iIdLockingType = int.Parse(dr.ItemArray[0].ToString()); et.sDescription = dr.ItemArray[1].ToString(); et.bStatus = bool.Parse(dr.ItemArray[2].ToString()); lst.Add(et); } return(lst); }