private void txtContCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select distinct ContCode,ContName From MastCont Where CompCode ='01' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ContCode", "ContCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtContCode.Text = obj.ElementAt(0).ToString();
}
}
}
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e)
{
if (txtCompCode.Text.Trim() == "")
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2 || e.KeyCode == Keys.F3 || e.KeyCode == Keys.F4)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select EmpUnqID,EmpName,FatherName,WrkGrp,Active,CompCode From MastEmp Where CompCode ='" + txtCompCode.Text.Trim() + "' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F2)
{
obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F3)
{
obj = (List <string>)hlp.Show(sql, "WrkGrp", "WrkGrp", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F4)
{
sql = "Select EmpUnqID,EmpName,FatherName,WrkGrp,Active,CompCode From MastEmp Where CompCode ='" + txtCompCode.Text.Trim() + "' and Active = 1 ";
obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtCompCode.Text = obj.ElementAt(5).ToString();
txtEmpUnqID.Text = obj.ElementAt(0).ToString();
txtEmpUnqID_Validated(sender, e);
}
}
}
private void txtDeptCode_KeyDown(object sender, KeyEventArgs e)
{
if (txtWrkGrpCode.Text.Trim() == "" || txtUnitCode.Text.Trim() == "")
{
txtWrkGrpCode.Text = "";
txtWrkGrpDesc.Text = "";
txtUnitCode.Text = "";
txtUnitDesc.Text = "";
txtDeptCode.Text = "";
txtDeptDesc.Text = "";
txtStatCode.Text = "";
txtStatDesc.Text = "";
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select DeptCode,DeptDesc From MastDept Where CompCode ='01' " +
" and WrkGrp = '" + txtWrkGrpCode.Text.Trim() + "' and UnitCode ='" + txtUnitCode.Text.Trim() + "'";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "DeptCode", "DeptCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "DeptDesc", "DeptDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtDeptCode.Text = obj.ElementAt(0).ToString();
txtDeptDesc.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select SubScriptionID,EmailTo,EmailCopy,BCCTo from AutoMailSubscription where 1 = 1";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "SubScriptionID", "SubScriptionID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F2)
{
obj = (List <string>)hlp.Show(sql, "EmailTo", "EmailTo", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F3)
{
obj = (List <string>)hlp.Show(sql, "EmailCopy", "EmailCopy", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F4)
{
obj = (List <string>)hlp.Show(sql, "BccTo", "BccTo", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtID.Text = obj.ElementAt(0).ToString();
txtEmail.Text = obj.ElementAt(1).ToString();
txtID_EditValueChanged(sender, e);
mode = "OLD";
}
}
}
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e)
{
if (string.IsNullOrEmpty(txtPayPeriod.Text.Trim()))
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select EmpUnqID,EmpName,PayPeriod from Cont_MastEmp " +
" Where PayPeriod = '" + txtPayPeriod.Text.Trim() + "'";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F2)
{
obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtEmpUnqID.Text = "";
txtEmpName.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtEmpUnqID.Text = "";
txtEmpName.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtEmpUnqID.Text = "";
txtEmpName.Text = "";
return;
}
else
{
txtEmpUnqID.Text = obj.ElementAt(0).ToString();
txtEmpName.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtUserID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select UserID,UserName,Pass,Active From Cont_MastUser Where Active = 1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "UserID", "UserID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F2)
{
obj = (List <string>)hlp.Show(sql, "UserName", "UserName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 200, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtUserID.Text = obj.ElementAt(0).ToString();
txtPersonName.Text = obj.ElementAt(1).ToString();
txtPassword.Text = obj.ElementAt(2).ToString();
if (obj.ElementAt(3).ToString().Trim() == "1")
{
chkActive.Checked = true;
}
else
{
chkActive.Checked = false;
}
mode = "OLD";
}
}
}
private void txtPayPeriod_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select PayPeriod,PayDesc,FromDt,ToDt from Cont_MastPayPeriod Where 1 = 1 Order by PayPeriod Desc ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "PayPeriod", "PayPeriod", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtPayPeriod.Text = "";
txtPayDesc.Text = "";
txtFromDt.EditValue = null;
txtToDt.EditValue = null;
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtPayPeriod.Text = "";
txtPayDesc.Text = "";
txtFromDt.EditValue = null;
txtToDt.EditValue = null;
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtPayPeriod.Text = "";
txtPayDesc.Text = "";
txtFromDt.EditValue = null;
txtToDt.EditValue = null;
return;
}
else
{
txtPayPeriod.Text = obj.ElementAt(0).ToString();
txtPayDesc.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select SrNo,UserID,WrkGrp,FormID from UserSpRight Where active = 1";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "SrNo", "SrNo", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "UserID", "UserID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtID.Text = obj.ElementAt(0).ToString();
txtUserID.Text = obj.ElementAt(1).ToString();
txtWrkGrpCode.Text = obj.ElementAt(2).ToString();
txtModuleID.Text = obj.ElementAt(3).ToString();
txtID_Validated(sender, e);
mode = "OLD";
}
}
}
private void txtPayPeriod_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
if (defSet)
{
sql = "Select distinct PayPeriod,'Default Settings' as PayDesc from Cont_ParaMast Where PayPeriod = 0 ";
}
else
{
sql = "Select PayPeriod,PayDesc,FromDt,ToDt from Cont_MastPayPeriod Where 1 = 1 ";
}
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "PayPeriod", "PayPeriod", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtPayPeriod.Text = "";
txtPayDesc.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtPayPeriod.Text = obj.ElementAt(0).ToString();
txtPayDesc.Text = obj.ElementAt(1).ToString();
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtPayPeriod.Text = "";
txtPayDesc.Text = "";
return;
}
else
{
txtPayPeriod.Text = obj.ElementAt(0).ToString();
txtPayDesc.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtSupervisorCode_KeyDown(object sender, KeyEventArgs e)
{
string sql = "";
string cnstr = "Data Source = 172.16.12.47;Initial Catalog=Attendance;User ID=attd;Password=attd123;";
sql = "Select EmpUnqID ,EmpName ,WrkGrp,EmpCode from MastEmp where Active = 1 and WrkGrp = 'Comp'";
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), cnstr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), cnstr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtSupervisorCode.Text = "";
txtSuperVisorName.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtSupervisorCode.Text = "";
txtSuperVisorName.Text = "";
return;
}
else
{
txtSupervisorCode.Text = obj.ElementAt(0).ToString();
txtSuperVisorName.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtMachineIP_KeyDown(object sender, KeyEventArgs e)
{
if (txtCompCode.Text.Trim() == "" || txtUnitCode.Text.Trim() == "" || txtMessCode.Text.Trim() == "")
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select MachineIP,MachineDesc from ReaderConfig Where CompCode ='" + txtCompCode.Text.Trim() + "' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "MachineIP", "MachineIP", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "MachineDesc", "MachineDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtMachineIP.Text = obj.ElementAt(0).ToString();
}
}
}
private void txtShiftCode_KeyDown(object sender, KeyEventArgs e)
{
if (ctrlEmp1.txtCompCode.Text.Trim() == "")
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select ShiftCode,ShiftDesc from MastShift Where CompCode ='" + ctrlEmp1.txtCompCode.Text.Trim() + "' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ShiftCode", "ShiftCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "ShiftDesc", "ShiftDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtShiftCode.Text = obj.ElementAt(0).ToString();
txtShiftDesc.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtID_KeyDown(object sender, KeyEventArgs e)
{
if (ctrlEmp1.txtCompCode.Text.Trim() == "" ||
ctrlEmp1.txtWrkGrpCode.Text.Trim() == "" ||
ctrlEmp1.txtEmpUnqID.Text.Trim() == ""
)
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select ID,MisConDt,MisConDesc From MastEmpMisConduct Where EmpUnqID ='" + ctrlEmp1.txtEmpUnqID.Text.Trim() + "' and DelFlg = 0 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ID", "ID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtID.Text = obj.ElementAt(0).ToString();
txtID_Validated(sender, e);
mode = "OLD";
}
}
}
private void txtRuleID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select RuleID,WrkGrp,Rules,RuleRepl from AttdRules Where 1 = 1";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "RuleID", "RuleID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "Rules", "Rules", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtRuleID.Text = obj.ElementAt(0).ToString();
txtWrkGrpCode.Text = obj.ElementAt(1).ToString();
txtRules.Text = obj.ElementAt(2).ToString();
txtRuleRepl.Text = obj.ElementAt(3).ToString();
mode = "OLD";
}
}
}
private void txtLeaveTyp_KeyDown(object sender, KeyEventArgs e)
{
if (txtCompCode.Text.Trim() == "" || txtWrkGrpCode.Text.Trim() == "")
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select LeaveTyp,LeaveDesc from MastLeave Where "
+ " CompCode ='" + txtCompCode.Text.Trim() + "' and "
+ " WrkGrp ='" + txtWrkGrpCode.Text.Trim() + "' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "LeaveTyp", "LeaveTyp", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtLeaveTyp.Text = obj.ElementAt(0).ToString();
txtDescription.Text = obj.ElementAt(1).ToString();
mode = "OLD";
}
}
}
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2 || e.KeyCode == Keys.F3)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select EmpUnqID,EmpName,WrkGrp,GradeDesc From v_EmpMast Where CompCode ='01' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F2)
{
obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "GradeDesc", "GradeDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtEmpUnqID.Text = obj.ElementAt(0).ToString();
txtEmpUnqID_Validated(sender, e);
}
}
}
private void txtSrNo_KeyDown(object sender, KeyEventArgs e)
{
if (string.IsNullOrEmpty(txtToolsID.Text.Trim()))
{
MessageBox.Show("Please Save record first, than enter inspection types", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select SrNo,InspTypeDesc,ToolsID From V_Tools_Insp_History Where ToolsID = '" + txtToolsID.Text.Trim() + "'";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "SrNo", "SrNo", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "InspTypeDesc", "InspTypeDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtSrNo.Text = obj.ElementAt(0).ToString();
}
}
}
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select EmpUnqID,EmpName,ContCode from MastEmp Where CompCode = '01' and WrkGrp = 'Cont' and Active = 1";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtEmpUnqID.Text = "";
txtEmpName.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtEmpUnqID.Text = "";
txtEmpName.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtEmpUnqID.Text = "";
txtEmpName.Text = "";
return;
}
else
{
txtEmpUnqID.Text = obj.ElementAt(0).ToString();
txtEmpName.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtDedCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select 'MESS' as DedCode , '*' Union Select 'MISC' as DedCode, '*' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "DedCode", "DedCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtDedCode.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtDedCode.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtDedCode.Text = "";
return;
}
else
{
txtDedCode.Text = obj.ElementAt(0).ToString();
txtDedCode_Validated(sender, e);
}
}
}
private void txtCostCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select CostCode,CostDesc From MastCostCode Where 1 = 1";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "CostCode", "CostCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "CostDesc", "CostDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtCostCode.Text = obj.ElementAt(0).ToString();
txtDescription.Text = obj.ElementAt(1).ToString();
mode = "OLD";
}
}
}
private void txtPshift_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2 || e.KeyCode == Keys.F3)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "select ShiftCode,'*' as t from MastShift where ShiftStart in ( " +
" SELECT [ShiftStart] FROM MastShift " +
" group by CompCode,ShiftStart " +
" having count(*) >= 2) ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ShiftCode", "ShiftCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtPshift.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtPshift.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtPshift.Text = "";
return;
}
else
{
txtPshift.Text = obj.ElementAt(0).ToString();
}
}
}
private void txtGroupCode_KeyDown(object sender, KeyEventArgs e)
{
if (txtCompCode.Text.Trim() == "" || txtWrkGrpCode.Text.Trim() == "")
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select GroupCode,GroupDesc From PBO_GroupMaster Where WrkGrp = '" + txtWrkGrpCode.Text.Trim() + "' ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "GroupCode", "GroupCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtGroupCode.Text = obj.ElementAt(0).ToString();
txtGroupDesc.Text = obj.ElementAt(1).ToString();
mode = "OLD";
}
}
}
private void txtModID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select FormID,FormName From Cont_MastFrm where 1 = 1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "FormID", "FormID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else if (e.KeyCode == Keys.F2)
{
obj = (List <string>)hlp.Show(sql, "FormName", "FormName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 200, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtModID.Text = obj.ElementAt(0).ToString();
txtModName.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtReasonCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select ReasonCode,ReasonDesc,PenaltyAmt From MastReason Where 1 =1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ReasonCode", "ReasonCode", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "ReasonDesc", "ReasonDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtReasonCode.Text = obj.ElementAt(0).ToString();
txtReasonDesc.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtEmailAccount_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select EmailAccount,EmailID From EmailConfig Where 1 =1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "EmailAccount", "EmailAccount", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "EmailID", "EmailID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtEmailAccount.Text = obj.ElementAt(0).ToString();
txtAccountPassword.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtWrkGrpCode_KeyDown(object sender, KeyEventArgs e)
{
if (txtRules.Text.Trim() == "")
{
return;
}
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select WrkGrp,WrkGrpDesc From MastWorkGrp Where 1 = 1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "WrkGrp", "WrkGrp", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtWrkGrpCode.Text = obj.ElementAt(0).ToString();
txtWrkGrpDesc.Text = obj.ElementAt(1).ToString();
}
}
}
private void txtSrNo_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select SrNo,EmpName,WrkGrp,ContCode From MastPreJoin Where 1=1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "SrNo", "SrNo", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtSrNo.Text = obj.ElementAt(0).ToString();
txtSrNo_Validated(sender, e);
}
}
}
private void txtTrID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select ID,ViolationDt,ViolationDesc,DefaulterType,DefaulterCode,DefaulterName From ViolationDt Where DelFlg = 0 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ID", "ID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "DefaulterName", "DefaulterName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtTrID.Text = obj.ElementAt(0).ToString();
}
}
}
private void txtInMachine_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select MachineIP,MachineDesc From ReaderConfig Where Active = 1 and CanteenFlg = 0 and IOFLG = 'I' and LunchInOut = 1 ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "MachineIP", "MachineIP", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
else
{
obj = (List <string>)hlp.Show(sql, "MachineDesc", "MachineDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
return;
}
else
{
txtInMachine.Text = obj.ElementAt(0).ToString();
}
}
}
private void txtContCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2)
{
List <string> obj = new List <string>();
Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp();
string sql = "";
sql = "Select Distinct ContCode,ContDesc from Cont_MastEmp Where PayPeriod = '" + txtPayPeriod.Text.Trim() + "' Order by ContCode Asc ";
if (e.KeyCode == Keys.F1)
{
obj = (List <string>)hlp.Show(sql, "ContCode", "ContCode", typeof(int), Utils.Helper.constr, "System.Data.SqlClient",
100, 300, 400, 600, 100, 100);
}
if (obj.Count == 0)
{
txtContCode.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "0")
{
txtContCode.Text = "";
return;
}
else if (obj.ElementAt(0).ToString() == "")
{
txtContCode.Text = "";
return;
}
else
{
txtContCode.Text = obj.ElementAt(0).ToString();
}
}
}
