public void AddNetConsumePoint(Int64 userID, string userName, tbl_NetConsumeDetail _netConsumeDetail)
{
try
{
CRUDOperation cRUDOperation = new CRUDOperation();
decimal pointValue = 0;
decimal priceValue = 0;
int operatorEVID = NetConsumeHelper.GetOperatorValueByKey(_netConsumeDetail.OperatorName.Trim());
NetConsumeRepository netConsumeRepository = new NetConsumeRepository();
if (_netConsumeDetail.Source_EVID == 4)
{
tbl_PackagePrice packagePrice = netConsumeRepository.GetPackagePrice(operatorEVID, _netConsumeDetail.Consumed);
if (packagePrice != null)
{
pointValue = 1 * (packagePrice.Point == null ? 0 : (decimal)packagePrice.Point);
priceValue = 1 * (packagePrice.Price == null ? 0 : (decimal)packagePrice.Price);
}
}
AddUserPointAndPrice(userID, _netConsumeDetail.Month, _netConsumeDetail.Year, pointValue, priceValue, (int)ChanelType.NetConsume);
}
catch (Exception)
{
}
}
public List <NetConsumeReportDTO> SW_GetNetConsumeReports(int userID, string userName, int year)
{
var result = new List <NetConsumeReportDTO>();
StringBuilder allQuery = new StringBuilder();
var query = @"select * from [GetNetUsage](@P_USERID,@P_year) ";
allQuery.Append(query);
using (var connection = new SqlConnection(ConnectionStrings.ConnectionString))
{
connection.Open();
using (var command = new SqlCommand(allQuery.ToString(), connection))
{
SqlParameter puserID = new SqlParameter("@P_USERID", SqlDbType.Int);
puserID.Value = userID;
command.Parameters.Add(puserID);
SqlParameter pyear = new SqlParameter("@P_year", SqlDbType.Int);
pyear.Value = year;
command.Parameters.Add(pyear);
var reader = command.ExecuteReader();
while (reader.Read())
{
NetConsumeReportDTO netConsumeReportDTO = new NetConsumeReportDTO()
{
INOUT_EVType = reader.GetInt32OrDefaultValue(0),
SourceDesc = reader.GetStringOrEmpty(1),
OperatorName = reader.GetStringOrEmpty(2),
Year = reader.GetInt32OrDefaultValue(3),
January = reader.GetDecimalOrDefaultValue2(4),
February = reader.GetDecimalOrDefaultValue2(5),
March = reader.GetDecimalOrDefaultValue2(6),
April = reader.GetDecimalOrDefaultValue2(7),
May = reader.GetDecimalOrDefaultValue2(8),
June = reader.GetDecimalOrDefaultValue2(9),
July = reader.GetDecimalOrDefaultValue2(10),
August = reader.GetDecimalOrDefaultValue2(11),
September = reader.GetDecimalOrDefaultValue2(12),
October = reader.GetDecimalOrDefaultValue2(13),
November = reader.GetDecimalOrDefaultValue2(14),
December = reader.GetDecimalOrDefaultValue2(15),
};
netConsumeReportDTO.Average = GetAverage(netConsumeReportDTO);
netConsumeReportDTO.OperatorEVID = NetConsumeHelper.GetOperatorValueByKey(netConsumeReportDTO.OperatorName);
if (netConsumeReportDTO.SourceDesc == "Mobil")
{
if (netConsumeReportDTO.Average == 0)
{
netConsumeReportDTO.AveragePrice = 0;
netConsumeReportDTO.AveragePoint = 0;
}
else
{
tbl_PackagePrice packagePrice = GetPackagePrice(netConsumeReportDTO.OperatorEVID, netConsumeReportDTO.Average);
if (packagePrice == null)
{
netConsumeReportDTO.AveragePrice = null;
netConsumeReportDTO.AveragePoint = null;
}
else
{
netConsumeReportDTO.AveragePrice = packagePrice.Price;
netConsumeReportDTO.AveragePoint = packagePrice.Point;
}
}
}
result.Add(netConsumeReportDTO);
}
}
connection.Close();
}
return(result);
}
