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