private void BindInit()
{
myCommon = new ACMS.Utils.Common();
DataTable dt;
dt = myCommon.ExecuteQuery("Select strBranchCode,strBranchName from tblBranch Where strBranchCode In (Select strBranchCode from tblemployeebranchrights Where nEmployeeId = " + EmployeeId + ")");
new ManagerBranchCodeLookupEditBuilder(dt, this.lkBranch.Properties);
dt = myCommon.ExecuteQuery("Select nEmployeeID, strEmployeeName from tblEmployee");
new ManagerEmployeeIDLookupEditBuilder(dt, this.lkEmployee.Properties);
string strSQL = "Select distinct datepart(year,dtDate) as nYearID from tblTimeCard order by datepart(year,dtDate) desc";
comboBind(Year, strSQL, "nYearID", "nYearID", true);
Year.SelectedIndex = 0;
comboBind(ToYear, strSQL, "nYearID", "nYearID", true);
ToYear.SelectedIndex = 0;
}
private void frmManager_Load(object sender, System.EventArgs e)
{
barstaticCurrentLogin.Caption = string.Format(barstaticCurrentLogin.Caption, employee.StrEmployeeName, DateTime.Now.ToString("dd MMMM yyyy"));
connectionString = (string)ConfigurationSettings.AppSettings["Main.ConnectionString"];
connection = new SqlConnection(connectionString);
TabManager_init();
FontStyle FontStyle001;
FontStyle001 = FontStyle.Bold;
FontStyle001 = (System.Drawing.FontStyle) System.Convert.ToInt32(FontStyle001)+System.Convert.ToInt32(FontStyle.Underline);
Font001 = new Font("Microsoft Sans Serif", 10, FontStyle001);
Font002 = new Font("Microsoft Sans Serif", 10, FontStyle.Bold);
Font003 = new Font("Microsoft Sans Serif", (float)8.25, FontStyle001);
Font004 = new Font("Microsoft Sans Serif", (float)8.25, FontStyle.Bold);
myCommon = new ACMS.Utils.Common();
frmRoster = new ACMS.ACMSManager.Human_Resource.frmRosterMain();
frmTimeSheet = new ACMS.ACMSManager.Human_Resource.frmTimeSheetMain();
frmOvertime = new ACMS.ACMSManager.Human_Resource.frmOvertimeMain();
frmHRLeave = new ACMS.ACMSManager.Human_Resource.frmLeave();
frmHRAppointment = new ACMS.ACMSManager.Human_Resource.frmAppointment();
//IPP
InitIPP();
LoadIPP();
//Payroll
Init_Payroll_cmbJob();
//Master Data
mdInit();
Init_Master_lookUp();
}
private void BindInit()
{
myCommon = new ACMS.Utils.Common();
DataTable dt;
dt = myCommon.ExecuteQuery("Select strBranchCode,strBranchName from tblBranch Where strBranchCode In (Select strBranchCode from tblemployeebranchrights Where nEmployeeId = " + EmployeeId + ")");
new ManagerBranchCodeLookupEditBuilder(dt, this.lkBranch.Properties);
dt = myCommon.ExecuteQuery("Select nEmployeeID, strEmployeeName from tblEmployee");
new ManagerEmployeeIDLookupEditBuilder(dt, this.lkEmployee.Properties);
string strSQL = "Select distinct datepart(year,dtDate) as nYearID from tblTimeCard order by datepart(year,dtDate) desc";
comboBind(Year, strSQL, "nYearID", "nYearID", true);
Year.SelectedIndex = 0;
comboBind(ToYear, strSQL, "nYearID", "nYearID", true);
ToYear.SelectedIndex = 0;
}
private void ClassHallInit()
{
string strSQL;
myCommon = new ACMS.Utils.Common();
strSQL = "select nHallNo, strHallName from tblHall";
DataTable dt2 = myCommon.ExecuteQuery(strSQL);
new ManagerHallCodeLookupEditBuilder(dt2, comboBoxHall.Properties);
if (dt2.Rows.Count > 0)
comboBoxHall.EditValue = dt2.Rows[0]["nHallNo"];
}
