protected void Delete_Click(object sender, EventArgs e)
{
ArrayList list = new ArrayList();
foreach (RepeaterItem i in Repeater.Items)
{
CheckBox cb = (CheckBox)i.FindControl("ItemSelect");
if (cb.Checked)
{
EEmpSpouse o = new EEmpSpouse();
WebFormUtils.GetKeys(sdb, o, cb);
list.Add(o);
}
}
if (list.Count > 0)
{
WebUtils.StartFunction(Session, FUNCTION_CODE, CurID);
foreach (BaseObject o in list)
{
if (sdb.select(dbConn, o))
{
sdb.delete(dbConn, o);
}
}
WebUtils.EndFunction(dbConn);
}
loadData(info, sdb, Repeater);
}
public void ImportToDatabase(int UploadEmpID)
{
DBFilter sessionFilter = new DBFilter();
sessionFilter.add(new Match("SessionID", m_SessionID));
if (UploadEmpID > 0)
{
sessionFilter.add(new Match("UploadEmpID", UploadEmpID));
}
ArrayList uploadEmpSpouseList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpSpouse obj in uploadEmpSpouseList)
{
EEmpSpouse empSpouse = new EEmpSpouse();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empSpouse.EmpSpouseID = obj.EmpSpouseID;
uploadDB.select(dbConn, empSpouse);
}
obj.ExportToObject(empSpouse);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
empSpouse.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, empSpouse);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empSpouse);
}
tempDB.delete(dbConn, obj);
}
}
protected void Delete_Click(object sender, EventArgs e)
{
EEmpSpouse c = new EEmpSpouse();
c.EmpSpouseID = CurID;
db.select(dbConn, c);
WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID);
db.delete(dbConn, c);
WebUtils.EndFunction(dbConn);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "EmpTab_Family_View.aspx?EmpID=" + EmpID.Value);
}
protected bool loadObject()
{
obj = new EEmpSpouse();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", CurEmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
if (EEmpPersonalInfo.db.count(dbConn, filter) == 0)
{
if (CurEmpID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (!db.select(dbConn, obj))
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (obj.EmpID != CurEmpID)
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
return(true);
}
protected bool loadObject()
{
obj = new EEmpSpouse();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", CurEmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
if (EEmpPersonalInfo.db.count(dbConn, filter) == 0)
{
if (CurEmpID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (!db.select(dbConn, obj))
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (obj.EmpID != CurEmpID)
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
// Start 0000142, KuangWei, 2014-12-20
double age = AppUtils.GetAge(obj.EmpSpouseDateOfBirth);
if (!double.IsNaN(age))
{
lblAge.Text = HROne.CommonLib.GenericRoundingFunctions.RoundingDown(age, 0, 3).ToString("0");
}
else
{
lblAge.Text = string.Empty;
}
// End 0000142, KuangWei, 2014-12-20
return(true);
}
protected void Save_Click(object sender, EventArgs e)
{
EEmpSpouse c = new EEmpSpouse();
Hashtable values = new Hashtable();
binding.toValues(values);
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
db.validate(errors, values);
if (EmpIsMedicalSchemaInsured.Checked)
{
if (string.IsNullOrEmpty(EmpMedicalEffectiveDate.TextBox.Text))
{
errors.addError("Please input Medical Effective Date");
}
if (string.IsNullOrEmpty(EmpMedicalExpiryDate.TextBox.Text))
{
errors.addError("Please input Expiry Date");
}
}
if (!errors.isEmpty())
{
return;
}
db.parse(values, c);
WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID);
if (CurID < 0)
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", c.EmpID));
ArrayList list = db.select(dbConn, filter);
if (list.Count > 0)
{
c.EmpSpouseID = ((EEmpSpouse)list[0]).EmpSpouseID;
db.update(dbConn, c);
}
else
{
db.insert(dbConn, c);
}
CurID = c.EmpSpouseID;
}
else
{
// Utils.Mark(Session, c);
db.update(dbConn, c);
}
WebUtils.EndFunction(dbConn);
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Emp_Spouse_View.aspx?EmpSpouseID=" + CurID + "&EmpID=" + c.EmpID);
}
public DataTable UploadToTempDatabase(DataTable rawDataTable, int UserID)
{
if (rawDataTable == null)
{
return(GetImportDataFromTempDatabase(null));
}
int rowCount = 1;
foreach (DataRow row in rawDataTable.Rows)
{
rowCount++;
EUploadEmpSpouse uploadEmpSpouse = new EUploadEmpSpouse();
EEmpSpouse lastEmpSpouse = null;
string EmpNo = row[FIELD_EMP_NO].ToString().Trim();
uploadEmpSpouse.EmpID = Parse.GetEmpID(dbConn, EmpNo, UserID);
if (uploadEmpSpouse.EmpID < 0)
{
errors.addError(ImportErrorMessage.ERROR_ACCESS_DENIED_EMP_NO, new string[] { EmpNo, rowCount.ToString() });
}
uploadEmpSpouse.EmpSpouseSurname = row[FIELD_SURNAME].ToString();
uploadEmpSpouse.EmpSpouseOtherName = row[FIELD_OTHER_NAME].ToString();
uploadEmpSpouse.EmpSpouseChineseName = row[FIELD_CHINESE_NAME].ToString();
try
{
// support old version template
if (rawDataTable.Columns.Contains(FIELD_DATE_OF_BIRTH))
{
uploadEmpSpouse.EmpSpouseDateOfBirth = Import.Parse.toDateTimeObject(row[FIELD_DATE_OF_BIRTH]);
}
}
catch
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_DATE_OF_BIRTH + "=" + row[FIELD_DATE_OF_BIRTH].ToString(), EmpNo, rowCount.ToString() });
}
uploadEmpSpouse.EmpSpouseHKID = row[FIELD_HKID].ToString().Trim();
uploadEmpSpouse.EmpSpousePassportNo = row[FIELD_PASSPORT_NUMBER].ToString();
uploadEmpSpouse.EmpSpousePassportIssuedCountry = row[FIELD_PASSPORT_ISSUE_COUNTRY].ToString();
// Start 0000142, KuangWei, 2014-12-21
uploadEmpSpouse.EmpGender = row[FIELD_SEX].ToString();
// Start 000142, Ricky So, 2015-01-08
//int tempInt = 0;
//if (int.TryParse(row[FIELD_MEDICAL_SCHEME_INSURED].ToString(), out tempInt))
// //uploadEmpSpouse.EmpIsMedicalSchemaInsured = tempInt;
// uploadEmpSpouse.EmpIsMedicalSchemaInsured = true;
//else
// uploadEmpSpouse.EmpIsMedicalSchemaInsured = false;
uploadEmpSpouse.EmpIsMedicalSchemaInsured = Parse.toBoolean(row[FIELD_MEDICAL_SCHEME_INSURED].ToString());
DateTime m_EffectiveDate = new DateTime();
DateTime m_ExpiryDate = new DateTime();
// End 000142, Ricky So, 2015-01-08
try
{
// support old version template
// Start 000142, Ricky So, 2015-01-08
//if (rawDataTable.Columns.Contains(FIELD_MEDICAL_EFFECTIVE_DATE))
// uploadEmpSpouse.EmpMedicalEffectiveDate = Import.Parse.toDateTimeObject(row[FIELD_MEDICAL_EFFECTIVE_DATE]);
if (rawDataTable.Columns.Contains(FIELD_MEDICAL_EFFECTIVE_DATE))
{
m_EffectiveDate = Import.Parse.toDateTimeObject(row[FIELD_MEDICAL_EFFECTIVE_DATE]);
}
// End 000142, Ricky So, 2015-01-08
}
catch
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_MEDICAL_EFFECTIVE_DATE + "=" + row[FIELD_MEDICAL_EFFECTIVE_DATE].ToString(), EmpNo, rowCount.ToString() });
}
try
{
// support old version template
// Start 000142, Ricky So, 2015-01-08
//if (rawDataTable.Columns.Contains(FIELD_EXPIRY_DATE))
// uploadEmpSpouse.EmpMedicalExpiryDate = Import.Parse.toDateTimeObject(row[FIELD_EXPIRY_DATE]);
if (rawDataTable.Columns.Contains(FIELD_EXPIRY_DATE))
{
m_ExpiryDate = Import.Parse.toDateTimeObject(row[FIELD_EXPIRY_DATE]);
}
// End 000142, Ricky So, 2015-01-08
}
catch
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_EXPIRY_DATE + "=" + row[FIELD_EXPIRY_DATE].ToString(), EmpNo, rowCount.ToString() });
}
// End 0000142, KuangWei, 2014-12-21
// Start 000142, Ricky So, 2015-01-08
if (uploadEmpSpouse.EmpIsMedicalSchemaInsured)
{
if (m_EffectiveDate.Ticks == 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_MEDICAL_EFFECTIVE_DATE + "=" + row[FIELD_MEDICAL_EFFECTIVE_DATE].ToString(), EmpNo, rowCount.ToString() });
}
if (m_ExpiryDate.Ticks == 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_EXPIRY_DATE + "=" + row[FIELD_EXPIRY_DATE].ToString(), EmpNo, rowCount.ToString() });
}
}
else
{
if (m_EffectiveDate.Ticks > 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_MEDICAL_EFFECTIVE_DATE + "=" + row[FIELD_MEDICAL_EFFECTIVE_DATE].ToString(), EmpNo, rowCount.ToString() });
}
if (m_ExpiryDate.Ticks > 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_EXPIRY_DATE + "=" + row[FIELD_EXPIRY_DATE].ToString(), EmpNo, rowCount.ToString() });
}
}
uploadEmpSpouse.EmpMedicalEffectiveDate = m_EffectiveDate;
uploadEmpSpouse.EmpMedicalExpiryDate = m_ExpiryDate;
// End 000142, Ricky So, 2015-01-08
uploadEmpSpouse.SessionID = m_SessionID;
uploadEmpSpouse.TransactionDate = UploadDateTime;
if (uploadEmpSpouse.EmpID != 0)
{
//if (rawDataTable.Columns.Contains(FIELD_INTERNAL_ID))
//{
// try
// {
// if (!row.IsNull(FIELD_INTERNAL_ID))
// {
// int tmpID = FromHexDecWithCheckDigit((string)row[FIELD_INTERNAL_ID]);
// EEmpSpouse tmpObj = new EEmpSpouse();
// tmpObj.EmpSpouseID = tmpID;
// if (EEmpSpouse.db.select(dbConn, tmpObj))
// uploadEmpSpouse.EmpSpouseID = tmpID;
// else
// {
// errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_INTERNAL_ID + "=" + row[FIELD_INTERNAL_ID].ToString(), EmpNo, rowCount.ToString() });
// continue;
// }
// }
// }
// catch (Exception ex)
// {
// errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_INTERNAL_ID + "=" + row[FIELD_INTERNAL_ID].ToString(), EmpNo, rowCount.ToString() });
// continue;
// }
//}
if (rawDataTable.Columns.Contains(FIELD_SYNC_ID))
{
if (!row.IsNull(FIELD_SYNC_ID))
{
string strSynID = row[FIELD_SYNC_ID].ToString();
uploadEmpSpouse.SynID = strSynID;
if (!string.IsNullOrEmpty(strSynID))
{
DBFilter synIDFilter = new DBFilter();
synIDFilter.add(new Match("SynID", strSynID));
ArrayList objSameSynIDList = EEmpSpouse.db.select(dbConn, synIDFilter);
if (objSameSynIDList.Count > 0)
{
uploadEmpSpouse.EmpSpouseID = ((EEmpSpouse)objSameSynIDList[0]).EmpSpouseID;
}
}
}
}
if (uploadEmpSpouse.EmpSpouseID == 0)
{
lastEmpSpouse = (EEmpSpouse)AppUtils.GetLastObj(dbConn, uploadDB, "EmpSpouseID", uploadEmpSpouse.EmpID);
if (lastEmpSpouse != null)
{
if (uploadEmpSpouse.EmpSpouseHKID == lastEmpSpouse.EmpSpouseHKID &&
uploadEmpSpouse.EmpSpouseSurname == lastEmpSpouse.EmpSpouseSurname &&
uploadEmpSpouse.EmpSpouseOtherName == lastEmpSpouse.EmpSpouseOtherName &&
uploadEmpSpouse.EmpSpouseChineseName == lastEmpSpouse.EmpSpouseChineseName &&
uploadEmpSpouse.EmpSpousePassportNo == lastEmpSpouse.EmpSpousePassportNo &&
uploadEmpSpouse.EmpSpousePassportIssuedCountry == lastEmpSpouse.EmpSpousePassportIssuedCountry &&
uploadEmpSpouse.EmpSpouseDateOfBirth == lastEmpSpouse.EmpSpouseDateOfBirth
// Start 0000142, KuangWei, 2014-12-21
&& uploadEmpSpouse.EmpGender == lastEmpSpouse.EmpGender &&
uploadEmpSpouse.EmpIsMedicalSchemaInsured == lastEmpSpouse.EmpIsMedicalSchemaInsured &&
uploadEmpSpouse.EmpMedicalEffectiveDate == lastEmpSpouse.EmpMedicalEffectiveDate &&
uploadEmpSpouse.EmpMedicalExpiryDate == lastEmpSpouse.EmpMedicalExpiryDate
// End 0000142, KuangWei, 2014-12-21
)
{
continue;
}
else
{
uploadEmpSpouse.EmpSpouseID = lastEmpSpouse.EmpSpouseID;
}
}
}
}
if (uploadEmpSpouse.EmpSpouseID <= 0)
{
uploadEmpSpouse.ImportActionStatus = ImportDBObject.ImportActionEnum.INSERT;
}
else
{
uploadEmpSpouse.ImportActionStatus = ImportDBObject.ImportActionEnum.UPDATE;
}
uploadEmpSpouse.UploadEmpID = ParseTemp.GetUploadEmpID(dbConn, EmpNo, m_SessionID);
if (uploadEmpSpouse.UploadEmpID == 0)
{
if (uploadEmpSpouse.EmpID == 0)
{
errors.addError(ImportErrorMessage.ERROR_INVALID_EMP_NO, new string[] { EmpNo, rowCount.ToString() });
}
else
{
uploadEmpSpouse.UploadEmpID = ImportEmpPersonalInfoProcess.CreateDummyUploadEmployeeInfo(dbConn, uploadEmpSpouse.EmpID, m_SessionID, UploadDateTime);
}
}
Hashtable values = new Hashtable();
tempDB.populate(uploadEmpSpouse, values);
PageErrors pageErrors = new PageErrors(EUploadEmpPersonalInfo.db);
tempDB.validate(pageErrors, values);
if (pageErrors.errors.Count == 0)
{
tempDB.insert(dbConn, uploadEmpSpouse);
}
else
{
pageErrors.addError(rawDataTable.TableName);
throw new HRImportException(pageErrors.getPrompt() + "(line " + rowCount.ToString() + ")");
}
}
if (errors.List.Count > 0)
{
ClearTempTable();
throw (new HRImportException(rawDataTable.TableName + "\r\n" + errors.Message()));
}
return(GetImportDataFromTempDatabase(null));
}