public static bool ExcelCompare(ExcelRowEntry Expected, ExcelRowEntry Actual)
{
if (Actual.Dtp.Value.ToShortDateString().Equals(Expected.Dtp.Value.ToShortDateString())
&& Actual.EntData[0].Equals(Expected.EntData[0]) && Actual.EntData[1].Equals(Expected.EntData[1])
&& Actual.EntData[2].Equals(Expected.EntData[2]) && Actual.EntData[3].Equals(Expected.EntData[3])
&& Actual.EntData[4].Equals(Expected.EntData[4]) && Actual.EntData[5].Equals(Expected.EntData[5]))
{
return true;
}
else
{
return false;
}
}
private void PlaceUpdate(ExcelRowEntry excelEntryRow, ref Excel.Worksheet workSheet, int rowNumber)
{
ExcelRowEntry tempRowEntry = new ExcelRowEntry();
while ((workSheet.get_Range(ExcelColumns.PROJECT + rowNumber).Value) != null)//allows insertion of updates before today
{
tempRowEntry.ExcelRetrieve(workSheet, rowNumber);
excelEntryRow.ExcelSheetUpdater(ref workSheet, rowNumber);
tempRowEntry.PutDataInto(ref excelEntryRow);
rowNumber++;
}
excelEntryRow.ExcelSheetUpdater(ref workSheet, rowNumber);
}
public void PutDataInto(ref ExcelRowEntry e)
{
e.CopyValue(Dtp, EntData, Bh, Ubh, ProjectType, HaveWork, ShiftTimings, UserStory, UpdatedTime, SubSystem);
}