protected bool loadObject()
{
EEmpPersonalInfo obj = new EEmpPersonalInfo();
bool isNew = WebFormWorkers.loadKeys(empDB, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", obj.EmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter);
if (empInfoList.Count == 0)
{
return(false);
}
obj = (EEmpPersonalInfo)empInfoList[0];
Hashtable values = new Hashtable();
empDB.populate(obj, values);
empBinding.toControl(values);
OldEmpNo.Text = EmpNo.Text;
EEmpPositionInfo empPos = AppUtils.GetLastPositionInfo(dbConn, CurEmpID);
values = new Hashtable();
empPosDB.populate(empPos, values);
empPosBinding.toControl(values);
return(true);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = sbinding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = "e.*, ep.EmpPayrollID";
string from = "from [" + db.dbclass.tableName + "] e, EmpPayroll ep, PayrollPeriod pp";
filter.add(new Match("PayGroupID", PayGroupID.SelectedValue));
filter.add(new MatchField("e.EmpID", "ep.EmpID"));
filter.add(new MatchField("ep.PayperiodID", "pp.PayperiodID"));
filter.add(new Match("ep.EmpPayStatus", "T"));
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
filter.add(new IN("e.EmpID", "Select EmpID From " + EEmpPersonalInfo.db.dbclass.tableName + " ee", EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime())));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
protected bool loadObject()
{
obj = new EEmpPersonalInfo();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", obj.EmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empPayrollList = EEmpPersonalInfo.db.select(dbConn, filter);
if (empPayrollList.Count == 0)
{
//IsAllowEdit = false;
Attendance_AttendanceRecordList.Visible = false;
return(false);
}
obj = (EEmpPersonalInfo)empPayrollList[0];
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
ucEmp_Header.CurrentEmpID = obj.EmpID;
return(true);
}
protected bool loadObject()
{
obj = new EEmpPersonalInfo();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", obj.EmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter);
if (empInfoList.Count == 0)
{
return(false);
}
obj = (EEmpPersonalInfo)empInfoList[0];
DBFilter empUniformFilter = new DBFilter();
empUniformFilter.add(new Match("EmpID", obj.EmpID));
ArrayList empUniformList = EEmpUniform.db.select(dbConn, empUniformFilter);
if (empUniformList.Count > 0)
{
EEmpUniform empUniform = (EEmpUniform)empUniformList[0];
EmpUniformB.Text = empUniform.EmpUniformB;
EmpUniformW.Text = empUniform.EmpUniformW;
EmpUniformH.Text = empUniform.EmpUniformH;
}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
return(true);
}
protected void RefreshMinimumWagesInfo()
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpPayrollID", CurID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empPayrollList = EEmpPayroll.db.select(dbConn, filter);
if (empPayrollList.Count == 0)
{
TotalWagesForMinimumWages.Text = string.Empty;
MinimumWagesRequired.Text = string.Empty;
return;
}
EEmpPayroll empPayroll = (EEmpPayroll)empPayrollList[0];
double dblTotalWagesForMinimumWages = 0;
double dblMinimumWagesRequired = 0;
EPayrollPeriod payPeriod = new EPayrollPeriod();
payPeriod.PayPeriodID = empPayroll.PayPeriodID;
if (EPayrollPeriod.db.select(dbConn, payPeriod))
{
dblTotalWagesForMinimumWages = HROne.Payroll.PayrollProcess.GetTotalWagesWithoutRestDayPayment(dbConn, empPayroll.EmpID, payPeriod.PayPeriodFr, payPeriod.PayPeriodTo, null);
}
double totalWorkingHour = HROne.Payroll.PayrollProcess.GetTotalEmpPayrollWorkingHours(dbConn, empPayroll.EmpID, empPayroll.PayPeriodID);
lblTotalWorkingHours.Text = totalWorkingHour.ToString();
dblMinimumWagesRequired = ((double)(HROne.Payroll.PayrollProcess.GetMinimumWages(dbConn, empPayroll.EmpID, payPeriod.PayPeriodTo) * totalWorkingHour));
TotalWagesForMinimumWages.Text = dblTotalWagesForMinimumWages.ToString("#,##0.00");
MinimumWagesRequired.Text = dblMinimumWagesRequired.ToString("#,##0.00");
if (dblMinimumWagesRequired - dblTotalWagesForMinimumWages <= 0.01)
{
btnAddAdditionalRemuneration.Visible = false;
}
else
{
EPayrollGroup payGroup = new EPayrollGroup();
payGroup.PayGroupID = payPeriod.PayGroupID;
if (EPayrollGroup.db.select(dbConn, payGroup))
{
if (payGroup.PayGroupAdditionalRemunerationPayCodeID > 0)
{
btnAddAdditionalRemuneration.Visible = true & toolBar.EditButton_Visible;
}
else
{
btnAddAdditionalRemuneration.Visible = false;
}
}
else
{
btnAddAdditionalRemuneration.Visible = false;
}
}
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = sbinding.createFilter();
filter.add(new Match("EmpID", this.CurID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
if (info != null && info.orderby != null && !info.orderby.Equals(""))
{
filter.add(info.orderby, info.order);
}
string select = "c.*";
string from = "from [" + sdb.dbclass.tableName + "] c ";
DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
string select = "e.* ";
string from = "from [" + db.dbclass.tableName + "] e ";
//DataTable table = filter.loadData(info, select, from);
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
public DataView PayrollProcessedLoadData(ListInfo info, DBManager db, DataList repeater)
{
DBFilter filter = sPayrollProcessedBinding.createFilter();
if (info != null && info.orderby != null && !info.orderby.Equals(""))
{
}
else
{
info.orderby = "CNDEffDate";
info.order = false;
}
string select = "c.* ";
string from = "from " + db.dbclass.tableName + " c ";
filter.add(new Match("PayRecID", ">", 0));
//filter.add(new Match("EmpPayrollID", ">", 0));
filter.add(WebUtils.AddRankFilter(Session, "c.EmpID", true));
DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info);
DataView view = new DataView(table);
if (PayrollProcessedRepeater != null)
{
PayrollProcessedRepeater.DataSource = view;
PayrollProcessedRepeater.DataBind();
}
return(view);
}
protected bool loadObject()
{
obj = new EEmpBankAccount();
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");
}
}
//DBFilter filter = new DBFilter();
//filter.add(new Match("EmpBankAccountID", obj.EmpBankAccountID));
//filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
//ArrayList empBankAccountList = EEmpBankAccount.db.select(dbConn, filter);
//if (empBankAccountList.Count == 0)
// return false;
//obj = (EEmpBankAccount)empBankAccountList[0];
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
return(true);
}
protected bool loadObject()
{
obj = new EEmpPositionInfo();
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");
}
}
//if (obj.EmpPosIsRosterTableGroupSupervisor)
// EmpPosIsRosterTableGroupSupervisor.Visible = true;
//else
// EmpPosIsRosterTableGroupSupervisor.Visible = false;
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
return(true);
}
protected bool loadObject(int EmpID)
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", EmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter);
if (empInfoList.Count == 0)
{
if (EmpID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
EEmpPersonalInfo obj = (EEmpPersonalInfo)empInfoList[0];
//if (obj.MasterEmpID > 0)
//{
// NewRoleEmpNo.Text = obj.EmpNo;
// EEmpPersonalInfo masterEmpInfo = new EEmpPersonalInfo();
// obj.EmpID = obj.MasterEmpID;
// if (!EEmpPersonalInfo.db.select(obj))
//}
//DBFilter empUniformFilter = new DBFilter();
//empUniformFilter.add(new Match("EmpID", obj.EmpID));
//ArrayList empUniformList = EEmpUniform.db.select(dbConn, empUniformFilter);
//if (empUniformList.Count > 0)
//{
// EEmpUniform empUniform = (EEmpUniform)empUniformList[0];
// EmpUniformB.Text = empUniform.EmpUniformB;
// EmpUniformW.Text = empUniform.EmpUniformW;
// EmpUniformH.Text = empUniform.EmpUniformH;
//}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
//EmpFullName.Text = obj.EmpEngFullName;
NewRoleEmpNoRoleRow.Visible = false;
if (obj.MasterEmpID > 0)
{
RoleEmpInfoPanel.Visible = true;
}
else
{
RoleEmpInfoPanel.Visible = false;
}
return(true);
}
protected bool loadObject()
{
obj = new EEmpWorkExp();
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);
if (EmpWorkExpToYear.Text.Equals("0"))
{
EmpWorkExpToYear.Text = string.Empty;
}
return(true);
}
protected bool loadObject()
{
obj = new EEmpDependant();
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 0000190, Miranda, 2015-04-30
isMedicalSchemeInsured(EmpDependantMedicalSchemeInsured.Checked);
//End 0000190, Miranda, 2015-04-30
return(true);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
if (info != null && info.orderby != null && !info.orderby.Equals(""))
{
filter.add(info.orderby, info.order);
}
string select = "e.*";
string from = "from [" + db.dbclass.tableName + "] e ";
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
DBFilter empPayrollFilter = new DBFilter();
empPayrollFilter.add(Payroll_PeriodSelectionList1.GetEmpPayrollDBTerm("ep"));
filter.add(new IN("e.EmpID", "SELECT DISTINCT ep.EmpID FROM " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter));
DBFilter payPeriodFilter = new SearchBinding(dbConn, EPayrollPeriod.db).createFilter();;
payPeriodFilter.add(new IN("pp.PayPeriodID", "SELECT DISTINCT ep.PayPeriodID FROM " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter));
string sqlStr = " min(pp.PayPeriodFr) as PayPeriodFr, max(pp.PayPeriodTo) as PayPeriodTo ";
string fromStr = " from [" + EPayrollPeriod.db.dbclass.tableName + "] pp ";
DataTable payPeriodTable = payPeriodFilter.loadData(dbConn, null, sqlStr, fromStr);
int rowCount = payPeriodTable.Rows.Count;
if (rowCount > 0 && !string.IsNullOrEmpty(payPeriodTable.Rows[0]["PayPeriodFr"].ToString()))
{
filter.add(new Match("e.EmpDateOfJoin", ">=", ((DateTime)payPeriodTable.Rows[0]["PayPeriodFr"]).ToString("yyyy/MM/dd")));
filter.add(new Match("e.EmpDateOfJoin", "<=", ((DateTime)payPeriodTable.Rows[0]["PayPeriodTo"]).ToString("yyyy/MM/dd")));
}
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e)
{
EClaimsAndDeductions obj = new EClaimsAndDeductions();
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("CNDID");
h.Value = obj.CNDID.ToString();
Label CNDAmount = (Label)e.Item.FindControl("CNDAmount");
Label CNDRemark = (Label)e.Item.FindControl("CNDRemark");
Label EmpAccID = (Label)e.Item.FindControl("EmpAccID");
Binding ebinding = new Binding(dbConn, db);
ebinding.add(CNDAmount);
ebinding.add(CNDRemark);
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)
{
CNDAmount.Text = obj.CNDAmount.ToString("$#,##0.00");
}
else
{
CNDAmount.Text = "******";
CNDRemark.Text = "******";
if (obj.CNDPayMethod.Equals("A", StringComparison.CurrentCultureIgnoreCase))
{
EmpAccID.Text = "******";
}
}
}
}
public DataView loadEmpData(ListInfo info, DBManager db, Repeater repeater)
{
WebDatePicker PayPeriodAsOFDate = (WebDatePicker)EmployeeSearchControl1.AdditionElementControl.FindControl("PayPeriodAsOFDate");
DBFilter filter = binding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = "e.*, ep.*, pp.PayPeriodFr, pp.PayperiodTo, pp.PayPeriodConfirmDate";
string from = "from [" + db.dbclass.tableName + "] e, EmpPayroll ep, PayrollPeriod pp ";
filter.add(new MatchField("e.EmpID", "ep.EmpID"));
filter.add(new MatchField("ep.PayperiodID", "pp.PayperiodID"));
filter.add(new Match("ep.EmpPayStatus", "C"));
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
DateTime dtPayPeriodAsOFDate;
if (DateTime.TryParse(PayPeriodAsOFDate.Value, out dtPayPeriodAsOFDate))
{
filter.add(new Match("pp.PayPeriodFr", "<=", dtPayPeriodAsOFDate));
filter.add(new Match("pp.PayPeriodTo", ">=", dtPayPeriodAsOFDate));
}
if (dtPayPeriodAsOFDate.Ticks.Equals(0))
{
dtPayPeriodAsOFDate = AppUtils.ServerDateTime().Date;
}
filter.add(new IN("e.EmpID", "Select EmpID from " + EEmpPersonalInfo.db.dbclass.tableName + " ee", EmployeeSearchControl1.GetEmpInfoFilter(dtPayPeriodAsOFDate, dtPayPeriodAsOFDate)));
//if (filter.getOrderClause().IndexOf("PayPeriodFr")<0)
// filter.add("EmpNo", true);
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = table;
repeater.DataBind();
}
return(view);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
if (info != null && info.orderby != null && !info.orderby.Equals(""))
{
filter.add(info.orderby, info.order);
}
string select = "et.EmpTermID, e.*";
string from = "from [" + db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL";
from += " inner join " + EEmpTermination.db.dbclass.tableName + " et on et.empid = e.empid ";
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
//DateTime dtLastEmploymentDateFrom, dtLastEmploymentDateTo;
//if (DateTime.TryParse(((WebDatePicker)EmployeeSearchControl1.AdditionElementControl.FindControl("LastEmploymentDateFrom")).Value, out dtLastEmploymentDateFrom))
// filter.add(new Match("et.EmpTermLastDate", ">=", dtLastEmploymentDateFrom));
//if (DateTime.TryParse(((WebDatePicker)EmployeeSearchControl1.AdditionElementControl.FindControl("LastEmploymentDateTo")).Value, out dtLastEmploymentDateTo))
// filter.add(new Match("et.EmpTermLastDate", "<=", dtLastEmploymentDateTo));
DBFilter empPayrollFilter = new DBFilter();
empPayrollFilter.add(Payroll_PeriodSelectionList1.GetEmpPayrollDBTerm());
DBFilter lastEmploymentDateFilter = new DBFilter();
lastEmploymentDateFilter.add(new MatchField("et.EmpTermLastDate", "<=", "tmpPP.PayPeriodTo"));
empPayrollFilter.add(new IN("ep.PayPeriodID", "SELECT tmpPP.PayPeriodID FROM " + EPayrollPeriod.db.dbclass.tableName + " tmpPP", lastEmploymentDateFilter));
filter.add(new IN("e.EmpID", "SELECT DISTINCT ep.EmpID FROM " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter));
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
// only staffs with commission calculation is configured through latest Recurring Payment
DBFilter m_rpFilter = new DBFilter();
OR m_or = new OR();
m_or.add(new NullTerm("EmpRPEffTo"));
m_or.add(new Match("EmpRPEffTo", ">=", Utility.LastDateOfMonth(AppUtils.ServerDateTime())));
m_rpFilter.add(new Match("EmpRPEffFr", "<=", Utility.LastDateOfMonth(AppUtils.ServerDateTime())));
m_rpFilter.add(m_or);
DBFilter m_isHitRateBasedFilter = new DBFilter();
m_isHitRateBasedFilter.add(new Match("PaymentCodeIsHitRateBased", true));
m_rpFilter.add(new IN("PayCodeID", "SELECT PaymentCodeID FROM PaymentCode", m_isHitRateBasedFilter));
filter.add(new IN("EmpID", "SELECT tmpRP.EmpID FROM EmpRecurringPayment tmpRP", m_rpFilter));
string select = "e.* ";
string from = "from [" + db.dbclass.tableName + "] e ";
//DataTable table = filter.loadData(info, select, from);
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
protected void Repeater_ItemDataBound(object sender, DataListItemEventArgs e)
{
ECommissionAchievement obj = new ECommissionAchievement();
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("CAID");
h.Value = obj.CAID.ToString();
Label CAPercent = (Label)e.Item.FindControl("CAPercent");
Label CAEffDate = (Label)e.Item.FindControl("CAEffDate");
Binding ebinding = new Binding(dbConn, db);
ebinding.add(CAPercent);
ebinding.add(CAEffDate);
// 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)
{
CAPercent.Text = obj.CAPercent.ToString("#0.00");
if (!obj.CAEffDate.Ticks.Equals(0))
{
CAEffDate.Text = obj.CAEffDate.ToString("yyyy-MM-dd");
}
}
else
{
CAPercent.Text = "******";
CAEffDate.Text = "******";
}
}
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = "e.*";
string from = "from [" + db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL";
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
//foreach (RepeaterItem item in HierarchyLevel.Items)
//{
// DBFilter sub = null;
// DropDownList c = (DropDownList)item.FindControl("HElementID");
// string v = c.SelectedValue;
// if (!v.Equals(""))
// {
// if (sub == null)
// {
// sub = new DBFilter();
// sub.add(new MatchField("p.EmpPosID", "EmpPosID"));
// }
// sub.add(new Match("HLevelID", c.Attributes["HLevelID"]));
// sub.add(new Match("HElementID", v));
// }
// if (sub != null)
// filter.add(new Exists(EEmpHierarchy.db.dbclass.tableName, sub));
//}
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
//protected bool loadObject()
//{
// obj = new EPayrollGroup();
// bool isNew = WebFormWorkers.loadKeys(EPayrollGroup.db, obj, DecryptedRequest);
// if (!EPayrollGroup.db.select(dbConn, obj))
// return false;
// Hashtable values = new Hashtable();
// EPayrollGroup.db.populate(obj, values);
// binding.toControl(values);
// if (CurPayPeriodID <= 0)
// {
// CurPayPeriodID = obj.CurrentPayPeriodID;
// }
// try
// {
// PayPeriodID.SelectedValue = CurPayPeriodID.ToString();
// ucPayroll_PeriodInfo.CurrentPayPeriodID = CurPayPeriodID;
// }
// catch (Exception ex)
// {
// CurPayPeriodID = 0;
// }
// if (PayPeriodID.SelectedIndex == 0)
// {
// CurPayPeriodID = 0;
// ucPayroll_PeriodInfo.CurrentPayPeriodID = 0;
// }
// if (CurPayPeriodID > 0)
// panelCostAllocationAdjustmentDetail.Visible = true;
// else
// panelCostAllocationAdjustmentDetail.Visible = false;
// return true;
//}
//protected void CostAllocationStatus_SelectedIndexChanged(object sender, EventArgs e)
//{
// Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + PayGroupID.SelectedValue + "&CostAllocationStatus=" + CostAllocationStatus.SelectedValue);
//}
//protected void PayGroupID_SelectedIndexChanged(object sender, EventArgs e)
//{
// Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + PayGroupID.SelectedValue + "&CostAllocationStatus=" + CostAllocationStatus.SelectedValue);
//}
//protected void PayPeriodID_SelectedIndexChanged(object sender, EventArgs e)
//{
// Response.Redirect(Request.Url.LocalPath + "?PayGroupID=" + PayGroupID.SelectedValue + "&PayPeriodID=" + PayPeriodID.SelectedValue + "&CostAllocationStatus=" + CostAllocationStatus.SelectedValue);
//}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = sbinding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = " e.*, ca.CostAllocationID ";
string from = "from " + EEmpPersonalInfo.db.dbclass.tableName + " e, " + ECostAllocation.db.dbclass.tableName + " ca, " + EEmpPayroll.db.dbclass.tableName + " ep, " + EPayrollPeriod.db.dbclass.tableName + " pp";
filter.add(new MatchField("e.EmpID", "ca.EmpID"));
filter.add(new MatchField("ca.EmpPayrollID", "ep.EmpPayrollID"));
filter.add(new MatchField("ep.PayPeriodID", "pp.PayPeriodID"));
filter.add(new Match("ca.CostAllocationStatus", CostAllocationStatus.SelectedValue));
//DBFilter empPayrollFilter = new DBFilter();
//empPayrollFilter.add(new Match("ep.EmpPayStatus", "C"));
//empPayrollFilter.add(new Match("ep.PayPeriodID", CurPayPeriodID));
// Start 0000129, Ricky So, 2014/11/11
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
// End 0000129, Ricky So, 2014/11/11
//DBFilter inCostAllocationFilter = new DBFilter();
//filter.add(new IN("ca.EmpPayrollID", "Select EmpPayrollID from " + EEmpPayroll.db.dbclass.tableName + " ep", empPayrollFilter));
DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info);
view = new DataView(table);
//if (info != null)
//{
// info.loadPageList(null, PrevPage, NextPage, FirstPage, LastPage);
// CurPage.Value = info.page.ToString();
// NumPage.Value = info.numPage.ToString();
//}
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = " e.*";
string from = "from [" + db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL";
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
DateTime dtEmpDateOfJoinFrom = new DateTime(), dtEmpDateOfJoinTo = new DateTime();
if (DateTime.TryParse(EmpDateOfJoinFrom.Value, out dtEmpDateOfJoinFrom))
{
filter.add(new Match("e.EmpDateOfJoin", ">=", dtEmpDateOfJoinFrom));
}
if (DateTime.TryParse(EmpDateOfJoinTo.Value, out dtEmpDateOfJoinTo))
{
filter.add(new Match("e.EmpDateOfJoin", "<=", dtEmpDateOfJoinTo));
}
filter.add(new NullTerm("NOT e.EmpDateOfJoin"));
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
public DataView loadData(ListInfo info, DBManager db, DataList repeater)
{
DBFilter filter = sbinding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
//{
// info.orderby = "is_processed, " + info.orderby;
//}
//else
//{
// info.orderby = "is_processed, CNDEffDate";
// info.order = false;
//}
//string select = "c.*, (CASE WHEN payrecid>0 THEN 1 Else 0 END) is_processed ";
//string from = "from " + db.dbclass.tableName + " c ";
if (info != null && info.orderby != null && !info.orderby.Equals(""))
{
}
else
{
info.orderby = "CNDEffDate";
info.order = false;
}
string select = "c.* ";
string from = "from " + db.dbclass.tableName + " c ";
filter.add(new NullTerm("PayRecID"));
filter.add(WebUtils.AddRankFilter(Session, "c.EmpID", true));
DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info);
DataView view = new DataView(table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
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);
{
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 = "******";
}
}
}
public DataView loadData2(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = new DBFilter();
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
int m_batchID = -1;
if (!int.TryParse(BatchID.SelectedValue, out m_batchID))
{
m_batchID = -1;
}
DBFilter m_batchFilter = new DBFilter();
m_batchFilter.add(new Match("CAImportBatchID", m_batchID));
filter.add(new IN("EmpID", "SELECT EmpID FROM CommissionAchievement ", m_batchFilter));
string select = "e.* ";
string from = "from [" + db.dbclass.tableName + "] e ";
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
protected bool loadObject()
{
ECostAllocation obj = new ECostAllocation();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("CostAllocationID", obj.CostAllocationID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList costAllocationList = db.select(dbConn, filter);
if (costAllocationList.Count == 0)
{
return(false);
}
obj = (ECostAllocation)costAllocationList[0];
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
ucEmp_Header.CurrentEmpID = obj.EmpID;
EEmpPayroll empPayroll = new EEmpPayroll();
empPayroll.EmpPayrollID = obj.EmpPayrollID;
EEmpPayroll.db.select(dbConn, empPayroll);
ucPayroll_PeriodInfo.CurrentPayPeriodID = empPayroll.PayPeriodID;
Payroll_CostAllocationList.CurrentCostAllocationID = obj.CostAllocationID;
//Payroll_PaymentRecordList.CurrentEmpPayrollID = obj.EmpPayrollID;
//Payroll_PaymentRecordList.CurrentEmpPayStatus = obj.EmpPayStatus;
//Payroll_MPFRecordList.CurrentEmpPayrollID = obj.EmpPayrollID;
//Payroll_MPFRecordList.CurrentEmpPayStatus = obj.EmpPayStatus;
//Payroll_ORSORecordList.CurrentEmpPayrollID = obj.EmpPayrollID;
//Payroll_ORSORecordList.CurrentEmpPayStatus = obj.EmpPayStatus;
return(true);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = addAuthorizerBinding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = "e.* ";
string from = "from [" + EEmpPersonalInfo.db.dbclass.tableName + "] e ";//LEFT JOIN " + EEmpPositionInfo.db.dbclass.tableName + " p ON c.EmpID=p.EmpID AND p.EmpPosEffTo IS NULL";
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
DBFilter empAuthorizerFilter = new DBFilter();
empAuthorizerFilter.add(new MatchField("e.empid", "ar.empid"));
empAuthorizerFilter.add(new Match("ar.AuthorizationGroupID", CurID));
filter.add(new Exists(EAuthorizer.db.dbclass.tableName + " ar", empAuthorizerFilter, true));
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
protected void btnAddAdditionalRemuneration_Click(object sender, EventArgs e)
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpPayrollID", CurID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empPayrollList = EEmpPayroll.db.select(dbConn, filter);
if (empPayrollList.Count == 0)
{
TotalWagesForMinimumWages.Text = string.Empty;
MinimumWagesRequired.Text = string.Empty;
return;
}
EEmpPayroll empPayroll = (EEmpPayroll)empPayrollList[0];
WebUtils.StartFunction(Session, FUNCTION_CODE.Value, empPayroll.EmpID);
HROne.Payroll.PayrollProcess.InsertAdditionalRemuneration(dbConn, empPayroll);
WebUtils.EndFunction(dbConn);
Payroll_PaymentRecordList.Refresh();
RefreshMinimumWagesInfo();
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = binding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
// only staffs with commission calculation is configured through latest Recurring Payment
DBTerm m_inCondition = CreateFilterByProcess(gProcessName, gPID);
if (m_inCondition != null)
{
filter.add(m_inCondition);
}
string select = "e.* ";
string from = "from [" + db.dbclass.tableName + "] e ";
DBFilter empInfoFilter = EmployeeSearchControl1.GetEmpInfoFilter(AppUtils.ServerDateTime(), AppUtils.ServerDateTime());
empInfoFilter.add(new MatchField("e.EmpID", "ee.EmpID"));
filter.add(new Exists(EEmpPersonalInfo.db.dbclass.tableName + " ee", empInfoFilter));
DataTable table = filter.loadData(dbConn, null, select, from);
table = EmployeeSearchControl1.FilterEncryptedEmpInfoField(table, info);
view = new DataView(table);
ListFooter.Refresh();
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
public DataView loadData(ListInfo info, DBManager db, Repeater repeater)
{
DBFilter filter = sbinding.createFilter();
//if (info != null && info.orderby != null && !info.orderby.Equals(""))
// filter.add(info.orderby, info.order);
string select = "e.*, ep.*";
string from = "from [" + db.dbclass.tableName + "] ep, EmpPersonalInfo e ";
filter.add(new MatchField("e.EmpID", "ep.EmpID"));
filter.add(Payroll_PeriodSelectionList1.GetEmpPayrollDBTerm("ep"));
filter.add(WebUtils.AddRankFilter(Session, "e.EmpID", true));
DataTable table = WebUtils.GetDataTableFromSelectQueryWithFilter(dbConn, select, from, filter, info);
if (table.Rows.Count > 0)
{
btnUndo.Visible = IsAllowEdit;
}
else
{
btnUndo.Visible = false;
}
view = new DataView(table);
if (repeater != null)
{
repeater.DataSource = view;
repeater.DataBind();
}
return(view);
}
