public override void ImportToDatabase()
{
DataTable dataTable = GetImportDataFromTempDatabase(null);
if (dataTable.Rows.Count > 0)
{
EIncentivePaymentImportBatch batchDetail = new EIncentivePaymentImportBatch();
batchDetail.IPImportBatchDateTime = AppUtils.ServerDateTime();
//batchDetail.IPImportBatchOriginalFilename = OriginalBatchFilename;
batchDetail.IPImportBatchRemark = Remark;
batchDetail.IPImportBatchUploadedBy = m_UserID;
EIncentivePaymentImportBatch.db.insert(dbConn, batchDetail);
foreach (DataRow row in dataTable.Rows)
{
EUploadIncentivePayment obj = new EUploadIncentivePayment();
EUploadIncentivePayment.db.toObject(row, obj);
EIncentivePayment IP = new EIncentivePayment();
IP.IPPercent = obj.IPPercent;
IP.IPEffDate = obj.IPEffDate;
IP.EmpID = obj.EmpID;
IP.IPImportBatchID = batchDetail.IPImportBatchID;
EIncentivePayment.db.insert(dbConn, IP);
EUploadIncentivePayment.db.delete(dbConn, obj);
}
}
}
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e)
{
EIncentivePayment obj = new EIncentivePayment();
db.toObject(((DataRowView)e.Item.DataItem).Row, obj);
Hashtable values = new Hashtable();
db.populate(obj, values);
{
//((Button)e.Item.FindControl("Edit")).Visible = IsAllowEdit;
//if (obj.PayRecID != null)
//{
// ((Button)e.Item.FindControl("Edit")).Visible = false;
// ((CheckBox)e.Item.FindControl("DeleteItem")).Visible = false;
//}
HtmlInputHidden h = (HtmlInputHidden)e.Item.FindControl("IPID");
h.Value = obj.IPID.ToString();
Label IPPercent = (Label)e.Item.FindControl("IPPercent");
Label IPEffDate = (Label)e.Item.FindControl("IPEffDate");
Binding ebinding = new Binding(dbConn, db);
ebinding.add(IPPercent);
ebinding.add(IPEffDate);
// ebinding.add(new BlankZeroLabelVLBinder(EEmpBankAccount.db, EmpAccID, "EmpAccID", EEmpBankAccount.VLBankAccount).setTextDisplayForZero(HROne.Common.WebUtility.GetLocalizedString(EEmpBankAccount.DEFAULT_BANK_ACCOUNT_TEXT)));
ebinding.init(Request, Session);
ebinding.toControl(values);
DBFilter empRankFilter = new DBFilter();
empRankFilter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
empRankFilter.add(new Match("EmpID", obj.EmpID));
if (EEmpPersonalInfo.db.count(dbConn, empRankFilter) > 0)
{
IPPercent.Text = obj.IPPercent.ToString("#0.00");
if (!obj.IPEffDate.Ticks.Equals(0))
{
IPEffDate.Text = obj.IPEffDate.ToString("yyyy-MM-dd");
}
}
else
{
IPPercent.Text = "******";
IPEffDate.Text = "******";
}
}
}
