/// <summary>
/// Query for Value In Transit Report
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public static List <ValueInTransit> GetValueInTransit(SqlConnection connection)
{
string query = "select SenderDistributionCentreId, SenderDistributionCentreName, ReceiverDistributionCentreId, RecieverDistributionCentreName, TotalPackages, TotalValue " +
"from ValueInTransit " +
"order by SenderDistributionCentreId, ReceiverDistributionCentreId ";
List <ValueInTransit> valueList = new List <ValueInTransit>();
var cmd = new SqlCommand(query);
cmd.Connection = connection;
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
var valueItem = new ValueInTransit();
if (reader["SenderDistributionCentreId"] != DBNull.Value)
{
valueItem.SenderDistributionCentreId = Convert.ToInt32(reader["SenderDistributionCentreId"]);
}
if (reader["SenderDistributionCentreName"] != DBNull.Value)
{
valueItem.SenderDistributionCentreName = (string)reader["SenderDistributionCentreName"];
}
if (reader["ReceiverDistributionCentreId"] != DBNull.Value)
{
valueItem.ReceiverDistributionCentreId = Convert.ToInt32(reader["ReceiverDistributionCentreId"]);
}
if (reader["RecieverDistributionCentreName"] != DBNull.Value)
{
valueItem.ReceiverDistributionCentreName = (string)reader["RecieverDistributionCentreName"];
}
if (reader["TotalPackages"] != DBNull.Value)
{
valueItem.TotalPackages = Convert.ToInt32(reader["TotalPackages"]);
}
if (reader["TotalValue"] != DBNull.Value)
{
valueItem.TotalValue = Convert.ToDecimal(reader["TotalValue"]);
}
valueList.Add(valueItem);
}
}
return(valueList);
}
public static List <ValueInTransit> getMockedValueInTransit()
{
List <ValueInTransit> transitList = new List <ValueInTransit>();
ValueInTransit v1 = new ValueInTransit();
v1.ReceiverDistributionCentreId = 1;
v1.RecieverDistributionCentreName = "Centre D";
v1.SenderDistributionCentreId = 2;
v1.SenderDistributionCentreName = "Cantre A";
v1.TotalPackages = 8;
v1.TotalValue = 45;
ValueInTransit v2 = new ValueInTransit();
v2.ReceiverDistributionCentreId = 2;
v2.RecieverDistributionCentreName = "Centre B";
v2.SenderDistributionCentreId = 3;
v2.SenderDistributionCentreName = "Cantre C";
v2.TotalPackages = 7;
v2.TotalValue = 65;
transitList.Add(v1); transitList.Add(v2);
return(transitList);
}
public string ValueInTransitToString(ValueInTransit v)
{
return("SenderId:" + v.SenderDistributionCentreId + " / SenderName:" + v.SenderDistributionCentreName + " / ReceiverId:" + v.ReceiverDistributionCentreId + " / ReceiverName:" + v.RecieverDistributionCentreName + " / NumbOfPs:" + v.TotalPackages + " / Value:" + v.TotalValue);
}
