private static PositionR GetPositionRFromReader(IDataReader dataReader) { PositionR objItem = new PositionR(); objItem.PositionID = SqlHelper.GetInt(dataReader, "PositionID"); objItem.PostionName = SqlHelper.GetString(dataReader, "PostionName"); objItem.MinSalary = SqlHelper.GetDecimal(dataReader, "MinSalary"); objItem.MaxSalary = SqlHelper.GetDecimal(dataReader, "MaxSalary"); return(objItem); }
public static PositionRCollection GetPostionRangesalary(int EntityID) { PositionRCollection collection = new PositionRCollection(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@EntityID", EntityID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Position_Range", sqlParams)) { while (reader.Read()) { PositionR obj = new PositionR(); obj = GetPositionRFromReader(reader); collection.Add(obj); } } return(collection); }