public void AddReferenceData(string _ColumeHead, string _writedata)
{
DataTable dtReport = new DataTable();
int columindex = 0;
try
{
if (refcount == 0)
{
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(DataFilePath, "sheet1");
if (dtReport.Rows.Count >= 1)
{
CreateDynamicFile(_ColumeHead);
AddData(_ColumeHead, _writedata);
}
refcount++;
}
else
{
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(DataFilePath, "sheet1");
int rowindex = dtReport.Rows.Count;
wSheet.Cells[rowindex + 1, columindex] = new Cell(_writedata);
wSheet.Cells[rowindex + 1, columindex + 1] = new Cell("0");
wBook.Save(DataFilePath);
}
}
catch (Exception e)
{
throw new Exception("Error while writing reference data to the File.");
}
}
public void FileCorreptionCheck()
{
try
{
if (new System.IO.FileInfo(DetailedReportFilePath).Length < 8192)
{
DataTable dtReport = new DataTable();
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(DetailedReportFilePath, LoginOperatrion.batchforReport + "_" + LoginOperatrion.requiredPlant);
Workbook loadBook = Workbook.Load(DetailedReportFilePath);
Worksheet loadSheet = loadBook.Worksheets[0];
int rowindex = dtReport.Rows.Count;
int columindex = 0;
if (rowindex <= 80)
{
int rows = 100 - rowindex;
for (int i = 0; i < rows; i++)
{
columindex = 25;
loadSheet.Cells[rowindex, columindex] = new Cell(" ");
rowindex++;
}
}
loadBook.Save(DetailedReportFilePath);
}
}
catch (Exception e) { }
}
public void FileCorreptionCheck()
{
try
{
if (new System.IO.FileInfo(DataFilePath).Length < 8192)
{
DataTable dtReport = new DataTable();
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(DataFilePath, "sheet1");
int rowindex = dtReport.Rows.Count;
int columindex = 0;
if (rowindex <= 80)
{
int rows = 150 - rowindex;
for (int i = 0; i < rows; i++)
{
columindex = 0;
wSheet.Cells[rowindex + 1, columindex] = new Cell("");
rowindex++;
}
}
wBook.Save(DataFilePath);
}
}
catch (Exception e) { }
}
public void AddData(string ColumHead, string WriteData)
{
DataTable dtReport = new DataTable();
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(DataFilePath, "sheet1");
getColumeIndexData(dtReport.Columns.Count, ColumHead);
wSheet.Cells[1, writecolumeIndex] = new Cell(WriteData);
refcount++;
wBook.Save(DataFilePath);
}
public void RecordFailReport(string _Stepno, string _Description, string _Keywords, string _Status, string _Batch, string _Filepath, string _RecordedData)
{
try
{
Workbook loadBook = Workbook.Load(_Filepath);
Worksheet loadSheet = new Worksheet(_Batch + "_" + LoginOperatrion.requiredPlant);
DataTable dtReport = new DataTable();
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(_Filepath, _Batch + "_" + LoginOperatrion.requiredPlant);
if (dtReport == null)
{
AddNewSheet(loadBook, loadSheet, _Batch, _Filepath);
dtReport = ExcelKeywordTable.ExcelData(_Filepath, _Batch + "_" + LoginOperatrion.requiredPlant);
}
int e = loadBook.Worksheets.Count - 1;
loadSheet = loadBook.Worksheets[e];
int rowindex = dtReport.Rows.Count;
int columindex = 0;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Stepno);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Description);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Keywords);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Status);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_RecordedData);
if (_Keywords != "Wait" && _Keywords != "SearchDataOperation" && _Keywords != "WaitPageLoad")
{
if (rowindex <= 80)
{
int rows = 100 - rowindex;
for (int i = 0; i < rows; i++)
{
columindex = 25;
loadSheet.Cells[rowindex, columindex] = new Cell(" ");
rowindex++;
}
}
}
loadBook.Save(_Filepath);
}
catch (Exception e) { }
}
public void UpdateData(string _Stepno, string _Description, string _Keywords, string _Status, string _Batch, string _Filepath, string _RecordedData)
{
try
{
Workbook loadBook = Workbook.Load(_Filepath);
Worksheet loadSheet = new Worksheet(_Batch + "_" + LoginOperatrion.requiredPlant);
DataTable dtReport = new DataTable();
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(_Filepath, _Batch + "_" + LoginOperatrion.requiredPlant);
if (dtReport == null)
{
AddNewSheet(loadBook, loadSheet, _Batch, _Filepath);
dtReport = ExcelKeywordTable.ExcelData(_Filepath, _Batch + "_" + LoginOperatrion.requiredPlant);
}
int e = loadBook.Worksheets.Count - 1;
loadSheet = loadBook.Worksheets[e];
int rowindex = dtReport.Rows.Count;
int columindex = 0;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Stepno);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Description);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Keywords);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_Status);
columindex++;
loadSheet.Cells[rowindex + 1, columindex] = new Cell(_RecordedData);
loadBook.Save(_Filepath);
}
catch (Exception e) { }
}
public void AddDataForReference(string _Filepath, string _columhead, string _writeData, string referencedata)
{
try
{
DataTable dtReport = new DataTable();
dtReport.Clear();
dtReport = ExcelKeywordTable.ExcelData(_Filepath, "sheet1");
int columeindex = dtReport.Columns.Count;
int rowindex = dtReport.Rows.Count;
int referenceDataCount = 0;
string material = string.Empty;
var Wbook = Workbook.Load(DataFilePath);
var Wsheet = Wbook.Worksheets[0];
#region RR
if (referencedata.Contains(','))
{
string[] MatchData = referencedata.Split(',');
if (MatchData.Count() > 1)
{
if (MatchData[0].StartsWith("Rec_"))
{
material = Operation.recordedData[MatchData[0].Replace("Rec_", string.Empty)].ToString();
}
else if (MatchData[0].StartsWith("Order"))
{
material = ExcelDataTable.ReadRefferenceInfoByOrder(MatchData[0].Split('=')[1], "Material");
}
else
{
material = ExcelDataTable.ReadData(1, MatchData[0]);
}
if (MatchData[1].Contains('+'))
{
string Store = ExcelDataTable.ReadData(1, MatchData[1].Split('+')[0]);
referencedata = material + ':' + ExcelDataTable.ReadRefferenceInfoByMaterialWithStore(Store, material, MatchData[1].Split('=')[1]);
}
else if (MatchData[1].StartsWith("Store"))
{
referencedata = ExcelDataTable.ReadData(1, MatchData[1].Split('=')[0]) + ':' + material;
}
getRefferenceIndexData(rowindex, columeindex, referencedata);
}
else
{
referencedata = ExcelDataTable.ReadData(1, MatchData[0]);
}
}
#endregion
getColumeIndexData(columeindex, _columhead);
if (writecolumeIndex == 0)
{
Wsheet.Cells[0, columeindex] = new Cell(_columhead);
Wbook.Save(_Filepath);
getColumeIndexData(columeindex, _columhead);
getRefferenceIndexData(rowindex, columeindex, referencedata);
if (writeRowIndex.Contains(','))
{
string[] rowcount = writeRowIndex.Split(',');
foreach (var row in rowcount)
{
if (row != string.Empty)
{
Wsheet.Cells[Convert.ToInt16(row), columeindex] = new Cell(_writeData);
}
}
}
else
{
Wsheet.Cells[Convert.ToInt16(writeRowIndex), columeindex] = new Cell(_writeData);
}
}
else
{
getRefferenceIndexData(rowindex, columeindex, referencedata);
if (referencedata.Contains(':'))
{
if (writeRowIndex.Contains(','))
{
string[] rowcount = writeRowIndex.Split(',');
foreach (var row in rowcount)
{
if (row != string.Empty)
{
Wsheet.Cells[Convert.ToInt16(row), writecolumeIndex] = new Cell(_writeData);
}
}
}
}
else
{
for (int a = 1; a <= rowindex; a++)
{
if (Wsheet.Cells[a, 0].StringValue == referencedata)
{
referenceDataCount++;
}
}
if (referenceDataCount > 1)
{
Wsheet.Cells[Convert.ToInt16(writeRowIndex) + 1, writecolumeIndex] = new Cell(_writeData);
}
else
{
Wsheet.Cells[Convert.ToInt16(writeRowIndex), writecolumeIndex] = new Cell(_writeData);
}
}
}
Wsheet.Cells.ColumnWidth[0, (ushort)columeindex] = 5000;
Wbook.Save(_Filepath);
}
catch (Exception e)
{
throw new Exception("Error while writing data for the reference data.");
}
}
