public string Read(CSVHandler csvHandler, string webpath, DoctorIncomeDataList doctorIncomeDataList)
{
throw new NotImplementedException();
}
public string Write(string fileName, string webpath, DoctorIncomeDataList displayResult)
{
// create a writer and open the file
if (!fileName.EndsWith(".csv"))
{
fileName += ".csv";
}
//string webpath = HttpContext.Current.Request.Url.AbsoluteUri;
string webFolderPath = webpath.Substring(0, webpath.LastIndexOf("/"));
string fileWebPath = webFolderPath + "/" + dataFolderName + "/" + fileName;
string fileStorageFilePath = resultStorageFolder + dataFolderName + "/" + fileName;
try
{
if (File.Exists(fileStorageFilePath))
{
File.Delete(fileStorageFilePath);
}
}
catch (Exception ex)
{
YelpTrace.Write(ex);
}
string header = string.Empty;
string rowText = string.Empty;
if (displayResult.LstDoctorIncomeDataList.Count > 0)
{
if (textWriter == null)
{
textWriter = new StreamWriter(fileStorageFilePath);
}
string reportHeader = string.Empty;
if (fileName.StartsWith("Conversion_Report"))
{
reportHeader = "Conversion Report as of " + DateTime.Today.ToShortDateString();
}
else
{
reportHeader = "Potential Profit/Loss Value Report as of " + DateTime.Today.ToShortDateString();
}
header = "Name, Email, Phone, First Consult, Treatment, Source, Status Group, Status, Treatment Cost, Aging";
header = reportHeader + Environment.NewLine + Environment.NewLine + Environment.NewLine + header;
if (!string.IsNullOrEmpty(header))
{
textWriter.WriteLine(header);
foreach (DoctorIncomeData doctorIncomeData in displayResult.LstDoctorIncomeDataList)
{
string joinedStr = doctorIncomeData.Name.Replace(",", " ") + ", ";
joinedStr += doctorIncomeData.Email.Replace(",", ";") + ", ";
joinedStr += doctorIncomeData.Phone.Replace(",", ";") + ", ";
string firstConsultDate = (doctorIncomeData.FirstConsultDate == null) ? string.Empty : doctorIncomeData.FirstConsultDate.ToShortDateString();
joinedStr += ((firstConsultDate.Equals("01/01/0001")) || (firstConsultDate.Equals("1/1/0001")) == true) ? string.Empty : firstConsultDate + ", ";
joinedStr += doctorIncomeData.Treatment.Replace(",", ";") + ", ";
joinedStr += doctorIncomeData.Source.Replace(",", ";") + ", ";
joinedStr += doctorIncomeData.StatusGroup.Replace(",", ";") + ", ";
joinedStr += doctorIncomeData.StatusName + ", ";
joinedStr += (doctorIncomeData.TxCost == 0) ? string.Empty : doctorIncomeData.TxCost.ToString("C2").Replace(",", "") + ", ";
joinedStr += (doctorIncomeData.Ageing == 0) ? string.Empty : doctorIncomeData.Ageing + ", ";
textWriter.WriteLine(joinedStr);
}
}
}
return(fileWebPath);
}