public override void ImportToDatabase()
{
DataTable dataTable = GetImportDataFromTempDatabase(null);
if (dataTable.Rows.Count > 0)
{
foreach (DataRow row in dataTable.Rows)
{
EUploadEmpWorkingSummary obj = new EUploadEmpWorkingSummary();
tempDB.toObject(row, obj);
EEmpWorkingSummary empWorkingSummary;
DBFilter dbFilter = new DBFilter();
dbFilter.add(new Match("EmpID", obj.EmpID));
dbFilter.add(new Match("EmpWorkingSummaryAsOfDate", obj.EmpWorkingSummaryAsOfDate));
ArrayList empWorkingSummaryList = EEmpWorkingSummary.db.select(dbConn, dbFilter);
if (empWorkingSummaryList.Count > 0)
{
empWorkingSummary = (EEmpWorkingSummary)empWorkingSummaryList[0];
}
else
{
empWorkingSummary = new EEmpWorkingSummary();
}
empWorkingSummary.EmpID = obj.EmpID;
empWorkingSummary.EmpWorkingSummaryAsOfDate = obj.EmpWorkingSummaryAsOfDate;
empWorkingSummary.EmpWorkingSummaryRestDayEntitled = obj.EmpWorkingSummaryRestDayEntitled;
empWorkingSummary.EmpWorkingSummaryRestDayTaken = obj.EmpWorkingSummaryRestDayTaken;
empWorkingSummary.EmpWorkingSummaryTotalWorkingDays = obj.EmpWorkingSummaryTotalWorkingDays;
empWorkingSummary.EmpWorkingSummaryTotalWorkingHours = obj.EmpWorkingSummaryTotalWorkingHours;
empWorkingSummary.EmpWorkingSummaryTotalLunchTimeHours = obj.EmpWorkingSummaryTotalLunchTimeHours;
if (empWorkingSummary.EmpWorkingSummaryID > 0)
{
EEmpWorkingSummary.db.update(dbConn, empWorkingSummary);
}
else
{
EEmpWorkingSummary.db.insert(dbConn, empWorkingSummary);
}
tempDB.delete(dbConn, obj);
}
}
}
public override DataTable UploadToTempDatabase(string Filename, int UserID, string ZipPassword)
{
ClearTempTable();
DataTable rawDataTable = HROne.Import.ExcelImport.parse(Filename, ZipPassword).Tables[0];
ArrayList results = new ArrayList();
int rowCount = 1;
try
{
foreach (DataRow row in rawDataTable.Rows)
{
rowCount++;
string EmpNo = row[FIELD_EMP_NO].ToString();
int EmpID = HROne.Import.Parse.GetEmpID(dbConn, EmpNo, UserID);
if (EmpID < 0)
{
errors.addError(ImportErrorMessage.ERROR_ACCESS_DENIED_EMP_NO, new string[] { EmpNo, rowCount.ToString() });
}
DateTime AsOfDate = Import.Parse.toDateTimeObject(row[FIELD_AS_OF_DATE]);
string RestDayEntitledString = row[FIELD_REST_DAY_ENTITLED].ToString();
string RestDayTakenString = row[FIELD_REST_DAY_TAKEN].ToString();
string TotalWorkingDaysString = row[FIELD_TOTAL_WORKING_DAYS].ToString();
string TotalWorkingHoursString = row[FIELD_TOTAL_WORKING_HOURS].ToString();
string TotalLunchTimeString = row[FIELD_TOTAL_LUNCH_HOURS].ToString();
double RestDayEntitled = 0;
double RestDayTaken = 0;
double TotalWorkingDays = 0;
double TotalWorkingHours = 0;
double TotalLunchTime = 0;
EUploadEmpWorkingSummary uploadEmpWorkingSummary = new EUploadEmpWorkingSummary();
uploadEmpWorkingSummary.EmpID = EmpID;
ArrayList additionUploadRecordList = new ArrayList();
if (EmpID > 0 && AsOfDate.Ticks != 0 &&
double.TryParse(RestDayEntitledString, out RestDayEntitled) &&
double.TryParse(RestDayTakenString, out RestDayTaken) &&
double.TryParse(TotalWorkingDaysString, out TotalWorkingDays) &&
double.TryParse(TotalWorkingHoursString, out TotalWorkingHours) &&
double.TryParse(TotalLunchTimeString, out TotalLunchTime)
)
{
uploadEmpWorkingSummary.EmpWorkingSummaryAsOfDate = AsOfDate;
uploadEmpWorkingSummary.EmpWorkingSummaryRestDayEntitled = RestDayEntitled;
uploadEmpWorkingSummary.EmpWorkingSummaryRestDayTaken = RestDayTaken;
uploadEmpWorkingSummary.EmpWorkingSummaryTotalWorkingDays = TotalWorkingDays;
uploadEmpWorkingSummary.EmpWorkingSummaryTotalWorkingHours = TotalWorkingHours;
uploadEmpWorkingSummary.EmpWorkingSummaryTotalLunchTimeHours = TotalLunchTime;
uploadEmpWorkingSummary.SessionID = m_SessionID;
uploadEmpWorkingSummary.TransactionDate = UploadDateTime;
results.Add(uploadEmpWorkingSummary);
DBFilter dbFilter = new DBFilter();
dbFilter.add(new Match("EmpID", uploadEmpWorkingSummary.EmpID));
dbFilter.add(new Match("EmpWorkingSummaryAsOfDate", uploadEmpWorkingSummary.EmpWorkingSummaryAsOfDate));
ArrayList list = EEmpWorkingSummary.db.select(dbConn, dbFilter);
foreach (EEmpWorkingSummary empWorkingSummary in list)
{
if (uploadEmpWorkingSummary.EmpWorkingSummaryID.Equals(0))
{
uploadEmpWorkingSummary.EmpWorkingSummaryID = empWorkingSummary.EmpWorkingSummaryID;
}
else
{
// Set Next Existing record to 0;
EUploadEmpWorkingSummary uploadNextWorkingSummary = new EUploadEmpWorkingSummary();
ImportDBObject.CopyObjectProperties(empWorkingSummary, uploadNextWorkingSummary);
uploadNextWorkingSummary.EmpWorkingSummaryRestDayEntitled = RestDayEntitled;
uploadNextWorkingSummary.EmpWorkingSummaryRestDayTaken = RestDayTaken;
uploadNextWorkingSummary.EmpWorkingSummaryTotalWorkingDays = TotalWorkingDays;
uploadNextWorkingSummary.EmpWorkingSummaryTotalWorkingHours = TotalWorkingHours;
uploadNextWorkingSummary.EmpWorkingSummaryTotalLunchTimeHours = TotalLunchTime;
uploadNextWorkingSummary.SessionID = m_SessionID;
uploadNextWorkingSummary.TransactionDate = UploadDateTime;
uploadNextWorkingSummary.ImportActionStatus = ImportDBObject.ImportActionEnum.UPDATE;
additionUploadRecordList.Add(uploadNextWorkingSummary);
}
}
}
else
{
double doubleValue;
if (EmpID == 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_EMP_NO, new string[] { EmpNo, rowCount.ToString() });
}
else if (AsOfDate.Ticks == 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_AS_OF_DATE + "=" + row[FIELD_AS_OF_DATE], EmpNo, rowCount.ToString() });
}
else if (!double.TryParse(RestDayEntitledString, out doubleValue))
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_REST_DAY_ENTITLED + "=" + RestDayEntitledString, EmpNo, rowCount.ToString() });
}
else if (!double.TryParse(RestDayTakenString, out doubleValue))
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_REST_DAY_TAKEN + "=" + RestDayTakenString, EmpNo, rowCount.ToString() });
}
else if (!double.TryParse(TotalWorkingDaysString, out doubleValue))
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_TOTAL_WORKING_DAYS + "=" + TotalWorkingDaysString, EmpNo, rowCount.ToString() });
}
else if (!double.TryParse(TotalWorkingHoursString, out doubleValue))
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_TOTAL_WORKING_HOURS + "=" + TotalWorkingHoursString, EmpNo, rowCount.ToString() });
}
else if (!double.TryParse(TotalLunchTimeString, out doubleValue))
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_TOTAL_LUNCH_HOURS + "=" + TotalLunchTimeString, EmpNo, rowCount.ToString() });
}
}
if (uploadEmpWorkingSummary.EmpWorkingSummaryID <= 0)
{
uploadEmpWorkingSummary.ImportActionStatus = ImportDBObject.ImportActionEnum.INSERT;
}
else
{
uploadEmpWorkingSummary.ImportActionStatus = ImportDBObject.ImportActionEnum.UPDATE;
}
if (errors.List.Count == 0)
{
Hashtable values = new Hashtable();
tempDB.populate(uploadEmpWorkingSummary, values);
PageErrors pageErrors = new PageErrors(tempDB);
tempDB.validate(pageErrors, values);
if (pageErrors.errors.Count == 0)
{
tempDB.insert(dbConn, uploadEmpWorkingSummary);
foreach (EUploadEmpWorkingSummary uploadNextWorkingSummary in additionUploadRecordList)
{
tempDB.insert(dbConn, uploadNextWorkingSummary);
}
}
else
{
pageErrors.addError(rawDataTable.TableName);
throw new HRImportException(pageErrors.getPrompt() + "(line " + rowCount.ToString() + ")");
}
}
}
}
catch (Exception e)
{
errors.addError(e.Message, null);
}
if (errors.List.Count > 0)
{
ClearTempTable();
throw (new HRImportException(rawDataTable.TableName + "\r\n" + errors.Message()));
}
return(GetImportDataFromTempDatabase(null));
}
