//Crystal View DataSourch
public DataTable CristalReportDataSourch(Telerik.Windows.Controls.RadGridView radgridview, DataTable tempDataTable, Variables.OperationTrypes oprationType)
{
string txtline = string.Empty;
NecessaryFunction necessaryElement = new NecessaryFunction();
GridViewExportOptions exportOption = new GridViewExportOptions();
exportOption.Format = ExportFormat.Text;
string fileNameWithPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "DATA_EXPORT.txt");
necessaryElement.CreateTextFile(fileNameWithPath);
FileStream fileStream = new FileStream(fileNameWithPath, FileMode.OpenOrCreate, FileAccess.Write);
radgridview.Export((Stream)fileStream, exportOption);
fileStream.Close();
fileStream.Dispose();
StreamReader txtReader = new StreamReader(fileNameWithPath);
while ((txtline=txtReader.ReadLine())!=null)
{
char[] delimiterChars = { ' ', '"', '\t' };
String[] columnData = txtline.Split(delimiterChars,StringSplitOptions.RemoveEmptyEntries);
if (oprationType.Equals(Variables.OperationTrypes.Sales))
{
tempDataTable.Rows.Add(columnData[0].Trim(), columnData[1].Trim(), columnData[2].Trim(), columnData[3].Trim());
}
else if (oprationType.Equals(Variables.OperationTrypes.InvPurDebCre))
{
tempDataTable.Rows.Add(columnData[0].Trim(), columnData[3].Trim(), columnData[4].Trim(), columnData[5].Trim(), columnData[6].Trim(), columnData[7].Trim(), columnData[8].Trim(), columnData[9].Trim(), columnData[11].Trim(), columnData[10].Trim());
}
}
txtReader.Close();
txtReader.Dispose();
necessaryElement.DeleteFile(fileNameWithPath);
return tempDataTable;
}
