private string GetRowDetailForDow(ExternalReportDTO item, string type)
{
var product = !string.IsNullOrEmpty(item.Product) ? item.Product.Replace(@",", ".") : "";
var startDate = string.Format("{0:MM/dd/yyyy,HH:mm}", item.ServiceStartDate) ?? "";
if (string.IsNullOrEmpty(startDate))
{
startDate = ",";
}
var finishDate = string.Format("{0:MM/dd/yyyy,HH:mm}", item.ServiceFinishDate) ?? "";
if (string.IsNullOrEmpty(finishDate))
{
finishDate = ",";
}
string textProperties = ExcelHelper.StringToCSVCell(item.Username) + "," + ExcelHelper.StringToCSVCell(item.Drivername) + "," + ExcelHelper.StringToCSVCell(item.EquipmentNumber) + "," + ExcelHelper.StringToCSVCell(item.ChassisNo) + "," +
ExcelHelper.StringToCSVCell(item.EquipmentStatusName) + "," + ExcelHelper.StringToCSVCell(item.Service) + "," + ExcelHelper.StringToCSVCell(product) + ", " +
ExcelHelper.StringToCSVCell(item.ChargeNo) + ", " + ExcelHelper.StringToCSVCell(item.OriginBlock) + "," + ExcelHelper.StringToCSVCell(item.DestinationBlock) + "," +
startDate + ",";
if (type == "internalHistoryReport")
{
textProperties += finishDate + ",";
}
textProperties += ExcelHelper.StringToCSVCell(item.DriverComments);
return(textProperties);
}
private string GetRowDetail(ExternalReportDTO item, decimal driverpay, string type)
{
var cb = String.Format("{0:0.00}", item.CustomerBill);
var cbWithFormat = cb.Replace(@",", ".");
var th = String.Format("{0:0.00}", item.ServiceTotalHours);
var thWithFormat = th.Replace(@",", ".");
var dp = String.Format("{0:0.00}", driverpay);
var dpWithFormat = dp.Replace(@",", ".");
var product = !string.IsNullOrEmpty(item.Product) ? item.Product.Replace(@",", ".") : "";
var startDate = string.Format("{0:MM/dd/yyyy,HH:mm,dddd}", item.ServiceStartDate) ?? "";
if (string.IsNullOrEmpty(startDate))
{
startDate = ",,";
}
var finishDate = string.Format("{0:MM/dd/yyyy,HH:mm,dddd}", item.ServiceFinishDate) ?? "";
if (string.IsNullOrEmpty(finishDate))
{
finishDate = ",,";
}
var chargeNo = item.ChargeNo;
if ((type == "internalHistoryReport" || type == "internalCurrentReport") && item.ChargeType == Constants.ChargeTypeCode.Shipment)
{
chargeNo = "\r00" + item.ChargeNo + "\r";
}
string textProperties = ExcelHelper.StringToCSVCell(item.Username) + "," + ExcelHelper.StringToCSVCell(item.EquipmentNumber) + "," + ExcelHelper.StringToCSVCell(item.EquipmentStatusName) + "," + ExcelHelper.StringToCSVCell(item.EquipmentSize) + "," +
ExcelHelper.StringToCSVCell(item.EquipmentType) + "," + ExcelHelper.StringToCSVCell(item.ChassisNo) + "," + ExcelHelper.StringToCSVCell(item.Service) + "," + ExcelHelper.StringToCSVCell(product) + ", " + ExcelHelper.StringToCSVCell(item.IsHazardousLabel) + "," + ExcelHelper.StringToCSVCell(chargeNo) + ", " +
ExcelHelper.StringToCSVCell(item.OriginBlock) + "," +
ExcelHelper.StringToCSVCell(item.DestinationBlock) + "," + ExcelHelper.StringToCSVCell(item.Approver) + "," + ExcelHelper.StringToCSVCell(item.ApprovalStatus) + "," + ExcelHelper.StringToCSVCell(item.DispatchingParty) + "," +
startDate + ",";
if (type == "internalHistoryReport" || type == "externalHistoryReport")
{
textProperties += finishDate + ",";
textProperties += ExcelHelper.StringToCSVCell(thWithFormat) + ",";
}
if (type == "internalHistoryReport" || type == "internalCurrentReport")
{
textProperties += ExcelHelper.StringToCSVCell(dpWithFormat) + ",";
}
textProperties += ExcelHelper.StringToCSVCell(cbWithFormat);
if (type == "internalHistoryReport" || type == "internalCurrentReport")
{
textProperties += "," + ExcelHelper.StringToCSVCell(item.DriverComments);
}
return(textProperties);
}
