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);
}