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 uploadEmpBeneficiariesList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpBeneficiaries obj in uploadEmpBeneficiariesList)
{
EEmpBeneficiaries EmpBeneficiaries = new EEmpBeneficiaries();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
EmpBeneficiaries.EmpBeneficiariesID = obj.EmpBeneficiariesID;
uploadDB.select(dbConn, EmpBeneficiaries);
}
obj.ExportToObject(EmpBeneficiaries);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
EmpBeneficiaries.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, EmpBeneficiaries);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, EmpBeneficiaries);
}
tempDB.delete(dbConn, obj);
}
}
public virtual 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 uploadEmpPayList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpRecurringPayment obj in uploadEmpPayList)
{
EEmpRecurringPayment empRP = new EEmpRecurringPayment();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empRP.EmpRPID = obj.EmpRPID;
uploadDB.select(dbConn, empRP);
}
obj.ExportToObject(empRP);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
empRP.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
AND andTerms = new AND();
andTerms.add(new Match("EmpRPEffFr", "<=", empRP.EmpRPEffFr));
andTerms.add(new Match("PayCodeID", empRP.PayCodeID));
EEmpRecurringPayment lastObj = (EEmpRecurringPayment)AppUtils.GetLastObj(dbConn, EEmpRecurringPayment.db, "EmpRPEffFr", empRP.EmpID, andTerms);
if (lastObj != null)
{
if (lastObj.EmpRPEffTo.Ticks == 0)
{
lastObj.EmpRPEffTo = empRP.EmpRPEffFr.AddDays(-1);
uploadDB.update(dbConn, lastObj);
}
}
if (obj.UploadEmpAccID > 0)
{
empRP.EmpAccID = ParseTemp.GetEmpBankAccIDFromUploadEmpBankAccID(dbConn, obj.UploadEmpAccID);
}
uploadDB.insert(dbConn, empRP);
//DBFilter emplastPosFilter = new DBFilter();
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empRP);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmppQualificationList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpQualification obj in uploadEmppQualificationList)
{
EEmpQualification empQualification = new EEmpQualification();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empQualification.EmpQualificationID = obj.EmpQualificationID;
uploadDB.select(dbConn, empQualification);
}
obj.ExportToObject(empQualification);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
//AND andTerms = new AND();
//andTerms.add(new Match("EmpQualificationFrom", "<=", empQualification.EmpQualificationFrom));
//andTerms.add(new Match("QualificationID", empQualification.QualificationID));
//EEmpQualification lastObj = (EEmpQualification)AppUtils.GetLastObj(dbConn, EEmpQualification.db, "EmpQualificationFrom", empQualification.EmpID, andTerms);
//if (lastObj != null)
// if (lastObj.EmpQualificationTo.Ticks == 0)
// {
// lastObj.EmpQualificationTo = empQualification.EmpQualificationFrom.AddDays(-1);
// uploadDB.update(dbConn, lastObj);
// }
empQualification.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, empQualification);
//DBFilter emplastPosFilter = new DBFilter();
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empQualification);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmpBankAccList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpBankAccount obj in uploadEmpBankAccList)
{
EEmpBankAccount empBankAcc = new EEmpBankAccount();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empBankAcc.EmpBankAccountID = obj.EmpBankAccountID;
uploadDB.select(dbConn, empBankAcc);
}
obj.ExportToObject(empBankAcc);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
empBankAcc.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, empBankAcc);
obj.EmpBankAccountID = empBankAcc.EmpBankAccountID;
tempDB.update(dbConn, obj);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empBankAcc);
}
if (empBankAcc.EmpAccDefault)
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpBankAccountID", "<>", empBankAcc.EmpBankAccountID));
filter.add(new Match("EmpID", empBankAcc.EmpID));
filter.add(new Match("EmpAccDefault", "<>", false));
EEmpBankAccount t = new EEmpBankAccount();
t.EmpAccDefault = false;
uploadDB.updateByTemplate(dbConn, t, filter);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmpTerminationList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpTermination obj in uploadEmpTerminationList)
{
EEmpTermination empTermination = new EEmpTermination();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empTermination.EmpTermID = obj.EmpTermID;
uploadDB.select(dbConn, empTermination);
}
obj.ExportToObject(empTermination);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
empTermination.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, empTermination);
// Upload Employee Status to Terminated
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empTermination.EmpID;
empInfo.EmpStatus = "T";
EEmpPersonalInfo.db.update(dbConn, empInfo);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empTermination);
// Upload Employee Status to Terminated
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empTermination.EmpID;
empInfo.EmpStatus = "T";
EEmpPersonalInfo.db.update(dbConn, empInfo);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmpPoRList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpPlaceOfResidence obj in uploadEmpPoRList)
{
EEmpPlaceOfResidence empPoR = new EEmpPlaceOfResidence();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empPoR.EmpPoRID = obj.EmpPoRID;
uploadDB.select(dbConn, empPoR);
}
obj.ExportToObject(empPoR);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
DBFilter emplastPosFilter = new DBFilter();
EEmpPlaceOfResidence lastObj = (EEmpPlaceOfResidence)AppUtils.GetLastObj(dbConn, uploadDB, "EmpPoRFrom", empPoR.EmpID, new Match("EmpPoRFrom", "<", empPoR.EmpPoRFrom));
if (lastObj != null)
{
if (lastObj.EmpPoRTo.Ticks == 0)
{
lastObj.EmpPoRTo = empPoR.EmpPoRFrom.AddDays(-1);
uploadDB.update(dbConn, lastObj);
}
}
empPoR.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, empPoR);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empPoR);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadLeaveAppList = tempDB.select(dbConn, sessionFilter);
//Dictionary<int, DateTime> recalLeaveBalanceDateList = new Dictionary<int, DateTime>();
foreach (EUploadLeaveApplication obj in uploadLeaveAppList)
{
ELeaveApplication leaveApplication = new ELeaveApplication();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
leaveApplication.LeaveAppID = obj.LeaveAppID;
uploadDB.select(dbConn, leaveApplication);
}
obj.ExportToObject(leaveApplication);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
leaveApplication.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, leaveApplication);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, leaveApplication);
}
tempDB.delete(dbConn, obj);
}
//foreach (int EmpID in recalLeaveBalanceDateList.Keys)
//{
// HROne.LeaveCalc.LeaveBalanceCalc leaaveBalCal = new HROne.LeaveCalc.LeaveBalanceCalc(dbConn, EmpID);
// leaaveBalCal.RecalculateAfter(recalLeaveBalanceDateList[EmpID]);
//}
}
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 uploadEmpRosterTableGroupList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpRosterTableGroup obj in uploadEmpRosterTableGroupList)
{
EEmpRosterTableGroup EmpRosterTableGroup = new EEmpRosterTableGroup();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
EmpRosterTableGroup.EmpRosterTableGroupID = obj.EmpRosterTableGroupID;
uploadDB.select(dbConn, EmpRosterTableGroup);
}
obj.ExportToObject(EmpRosterTableGroup);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
EmpRosterTableGroup.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
//DBFilter emplastPosFilter = new DBFilter();
//EEmpRosterTableGroup lastObj = (EEmpRosterTableGroup)AppUtils.GetLastObj(dbConn, uploadDB, "EmpRosterTableGroupEffFr", EmpRosterTableGroup.EmpID, new Match("EmpRosterTableGroupEffFr", "<", EmpRosterTableGroup.EmpRosterTableGroupEffFr));
//if (lastObj != null)
// if (lastObj.EmpRosterTableGroupEffTo.Ticks == 0)
// {
// lastObj.EmpRosterTableGroupEffTo = EmpRosterTableGroup.EmpRosterTableGroupEffFr.AddDays(-1);
// uploadDB.update(dbConn, lastObj);
// }
uploadDB.insert(dbConn, EmpRosterTableGroup);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, EmpRosterTableGroup);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmpAVCList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpAVCPlan obj in uploadEmpAVCList)
{
EEmpAVCPlan empAVCPlan = new EEmpAVCPlan();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empAVCPlan.EmpAVCID = obj.EmpAVCID;
uploadDB.select(dbConn, empAVCPlan);
}
obj.ExportToObject(empAVCPlan);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
empAVCPlan.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
DBFilter emplastPosFilter = new DBFilter();
EEmpAVCPlan lastObj = (EEmpAVCPlan)AppUtils.GetLastObj(dbConn, uploadDB, "EmpAVCEffFr", empAVCPlan.EmpID, new Match("EmpAVCEffFr", "<", empAVCPlan.EmpAVCEffFr));
if (lastObj != null)
if (lastObj.EmpAVCEffTo.Ticks == 0)
{
lastObj.EmpAVCEffTo = empAVCPlan.EmpAVCEffFr.AddDays(-1);
uploadDB.update(dbConn, lastObj);
}
uploadDB.insert(dbConn, empAVCPlan);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empAVCPlan);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmpFinalPayList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpFinalPayment obj in uploadEmpFinalPayList)
{
EEmpFinalPayment EmpFinalPay = new EEmpFinalPayment();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
EmpFinalPay.EmpFinalPayID = obj.EmpFinalPayID;
uploadDB.select(dbConn, EmpFinalPay);
}
obj.ExportToObject(EmpFinalPay);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
EmpFinalPay.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
if (obj.UploadEmpAccID > 0)
{
EmpFinalPay.EmpAccID = ParseTemp.GetEmpBankAccIDFromUploadEmpBankAccID(dbConn, obj.UploadEmpAccID);
}
uploadDB.insert(dbConn, EmpFinalPay);
//DBFilter emplastPosFilter = new DBFilter();
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, EmpFinalPay);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadLeaveBalanceAdjustment obj in uploadList)
{
ELeaveBalanceAdjustment leaveBalanceAdjustment = new ELeaveBalanceAdjustment();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
leaveBalanceAdjustment.LeaveBalAdjID = obj.LeaveBalAdjID;
uploadDB.select(dbConn, leaveBalanceAdjustment);
}
obj.ExportToObject(leaveBalanceAdjustment);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
leaveBalanceAdjustment.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, leaveBalanceAdjustment);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, leaveBalanceAdjustment);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadCompensationLeaveEntitle obj in uploadList)
{
ECompensationLeaveEntitle compLeaveEntitle = new ECompensationLeaveEntitle();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
compLeaveEntitle.CompensationLeaveEntitleID = obj.CompensationLeaveEntitleID;
uploadDB.select(dbConn, compLeaveEntitle);
}
obj.ExportToObject(compLeaveEntitle);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
compLeaveEntitle.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
uploadDB.insert(dbConn, compLeaveEntitle);
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, compLeaveEntitle);
}
tempDB.delete(dbConn, obj);
}
}
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 uploadEmpCostCenterList = tempDB.select(dbConn, sessionFilter);
foreach (EUploadEmpCostCenter obj in uploadEmpCostCenterList)
{
EEmpCostCenter empCostCenter = new EEmpCostCenter();
if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT)
{
empCostCenter.EmpCostCenterID = obj.EmpCostCenterID;
uploadDB.select(dbConn, empCostCenter);
}
obj.ExportToObject(empCostCenter);
if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT)
{
empCostCenter.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID);
EEmpCostCenter lastObj = (EEmpCostCenter)AppUtils.GetLastObj(dbConn, EEmpCostCenter.db, "EmpCostCenterEffFr", empCostCenter.EmpID, new Match("EmpCostCenterEffFr", "<", empCostCenter.EmpCostCenterEffFr));
if (lastObj != null)
{
if (lastObj.EmpCostCenterEffTo.Ticks == 0)
{
lastObj.EmpCostCenterEffTo = empCostCenter.EmpCostCenterEffFr.AddDays(-1);
uploadDB.update(dbConn, lastObj);
}
}
uploadDB.insert(dbConn, empCostCenter);
DBFilter uploadEmpCostCenterFilter = new DBFilter();
uploadEmpCostCenterFilter.add(new Match("UploadEmpCostCenterID", obj.UploadEmpCostCenterID));
ArrayList uploadEmpCostCenterDetailList = EUploadEmpCostCenterDetail.db.select(dbConn, uploadEmpCostCenterFilter);
foreach (EUploadEmpCostCenterDetail uploadEmpCostCenterDetail in uploadEmpCostCenterDetailList)
{
uploadEmpCostCenterDetail.EmpCostCenterID = empCostCenter.EmpCostCenterID;
EEmpCostCenterDetail empCostCenterDetail = new EEmpCostCenterDetail();
ImportDBObject.CopyObjectProperties(uploadEmpCostCenterDetail, empCostCenterDetail);
uploadDetailDB.insert(dbConn, empCostCenterDetail);
EUploadEmpCostCenterDetail.db.delete(dbConn, uploadEmpCostCenterDetail);
}
}
else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE)
{
uploadDB.update(dbConn, empCostCenter);
DBFilter empCostCenterDetailFilter = new DBFilter();
empCostCenterDetailFilter.add(new Match("EmpCostCenterID", empCostCenter.EmpCostCenterID));
uploadDetailDB.delete(dbConn, empCostCenterDetailFilter);
DBFilter uploadEmpCostCenterDetailFilter = new DBFilter();
uploadEmpCostCenterDetailFilter.add(new Match("UploadEmpCostCenterID", obj.UploadEmpCostCenterID));
ArrayList uploadEmpCostCenterDetailList = EUploadEmpCostCenterDetail.db.select(dbConn, uploadEmpCostCenterDetailFilter);
foreach (EUploadEmpCostCenterDetail uploadEmpCostCenterDetail in uploadEmpCostCenterDetailList)
{
EEmpCostCenterDetail empCostCenterDetail = new EEmpCostCenterDetail();
ImportDBObject.CopyObjectProperties(uploadEmpCostCenterDetail, empCostCenterDetail);
uploadDetailDB.insert(dbConn, empCostCenterDetail);
EUploadEmpCostCenterDetail.db.delete(dbConn, uploadEmpCostCenterDetail);
}
}
tempDB.delete(dbConn, obj);
}
}
