// ******************************************************
public static List <DistributionCentreLosses> getMockedLosses()
{
//List<Package> packagesList = MockDataAccess.GetAllPackages();
List <DistributionCentreLosses> lossesList = new List <DistributionCentreLosses>();
DistributionCentreLosses l1 = new DistributionCentreLosses();
l1.DistributionCenterName = "CentreA";
l1.DistributionCentreId = 1;
l1.LossRatioDenominator = 75;
l1.LossRatioNumerator = 12;
l1.TotalLossDiscardedValue = 445;
DistributionCentreLosses l2 = new DistributionCentreLosses();
l2.DistributionCenterName = "CentreB";
l2.DistributionCentreId = 2;
l2.LossRatioDenominator = 275;
l2.LossRatioNumerator = 18;
l2.TotalLossDiscardedValue = 1445;
DistributionCentreLosses l3 = new DistributionCentreLosses();
l3.DistributionCenterName = "CentreC";
l3.DistributionCentreId = 3;
l3.LossRatioDenominator = 175;
l3.LossRatioNumerator = 22;
l3.TotalLossDiscardedValue = 335;
lossesList.Add(l1); lossesList.Add(l2); lossesList.Add(l3);
return(lossesList);
}
public List <DistributionCentreLosses> GetDistributionCentreLosses()
{
var lossesList = new List <DistributionCentreLosses>();
var loss = new DistributionCentreLosses()
{
DistributionCentreId = 1,
DistributionCenterName = "North Centre",
LossRatioNumerator = 5,
LossRatioDenominator = 15,
TotalLossDiscardedValue = 500
};
lossesList.Add(loss);
return(lossesList);
}
/// <summary>
/// Query for Distribution Centre Losses Report
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public static List <DistributionCentreLosses> GetDistributionCentreLosses(SqlConnection connection)
{
string query = "select DistributionCentreId, DistributionCenterName, LossRatioNumerator, LossRatioDenominator, TotalLossDiscardedValue " +
"from DistributionCentreLosses " +
"order by DistributionCentreId";
List <DistributionCentreLosses> centreList = new List <DistributionCentreLosses>();
var cmd = new SqlCommand(query);
cmd.Connection = connection;
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
var centre = new DistributionCentreLosses();
if (reader["DistributionCentreId"] != DBNull.Value)
{
centre.DistributionCentreId = Convert.ToInt32(reader["DistributionCentreId"]);
}
if (reader["DistributionCenterName"] != DBNull.Value)
{
centre.DistributionCentreName = (string)reader["DistributionCenterName"];
}
if (reader["LossRatioNumerator"] != DBNull.Value)
{
centre.LossRatioNumerator = Convert.ToInt32(reader["LossRatioNumerator"]);
}
if (reader["LossRatioDenominator"] != DBNull.Value)
{
centre.LossRatioDenominator = Convert.ToInt32(reader["LossRatioDenominator"]);
}
if (reader["TotalLossDiscardedValue"] != DBNull.Value)
{
centre.TotalLossDiscardedValue = Convert.ToDecimal(reader["TotalLossDiscardedValue"]);
}
centreList.Add(centre);
}
}
return(centreList);
}
public string LossesToString(DistributionCentreLosses l)
{
return("C_Id:" + l.DistributionCentreId + " / C_Name:" + l.DistributionCenterName + " / Ratio:" + l.LossRatioNumerator + "/" + l.LossRatioDenominator + " / Value:" + l.TotalLossDiscardedValue);
}
