/// <summary>
/// Handles the Click event of the btnLogin control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
/// <remarks></remarks>
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (txtUserid.Text.Trim() == string.Empty)
{
errorProvider1.SetError(txtUserid, "Enter UserId");
txtUserid.Focus();
}
else
{
errorProvider1.Clear();
}
if (txtPassword.Text.Trim() == string.Empty)
{
errorProvider1.SetError(txtPassword, "Enter Password");
}
else
{
errorProvider1.Clear();
}
if (txtUserid.Text.Trim() != "" && txtPassword.Text.Trim() != "")
{
//dslogin = GC.ExcelConnectivity("Select * from [User$] where [Emp No] ='" + txtUserid.Text.Trim() + "' and Password='******' ", "OleDbConnString_UserLoginVisakhapatnam");
dslogin = GC.ExcelConnectivity("Select * from [Sheet1$] where [Emp No] ='" + txtUserid.Text.Trim() + "' and Password='******' ", "OleDbConnString_UserLogin_" + "" + locationType + "");
// checking the credentials of auser
if (dslogin.Tables[0].Rows.Count > 0)
{
this.Close();
Member_Account objMA = new Member_Account(dslogin.Tables[0].Rows[0]["Emp No"].ToString(), dslogin.Tables[0].Rows[0]["Employee Name"].ToString(), locationType); // redirecting to Member Account
objMA.Show();
}
else
{
lblerror.Text = "The UserId or Password you entered is incorrect.";
txtUserid.Text = "";
txtPassword.Text = "";
txtUserid.Focus();
}
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
lblRelogin.Text = "Please Relogin";
txtUserid.Text = "";
txtPassword.Text = "";
txtUserid.Focus();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="LIC_Policies"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <remarks></remarks>
public LIC_Policies(string EmpId, string EmpName, string locallocationType)
{
InitializeComponent();
localEmpId = EmpId;
localEmpName = EmpName;
lblExName.Text = EmpName;
locationType = locallocationType;
// lblDt.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblDt.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
MessageBox.Show("Entered into wrong data");
}
try
{
//Query for Geting Data form Excel sheet
dsLIC = GC.ExcelConnectivity("select * from [Sheet1$] where [Emp No] = " + EmpId + "", "OleDbConnString_LIC_Policies");
if (dsLIC.Tables[0].Rows.Count > 0)
{
dgvLIC.AutoGenerateColumns = true;
bindingSource1.DataSource = dsLIC.Tables[0];
dgvLIC.DataSource = bindingSource1;
}
else
{
lblError.Visible = true;
lblError.Text = "No Details Available";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
this.Close();
Employee_Lgn ObjEL = new Employee_Lgn(locationType);
ObjEL.Show();
lblError.Visible = true;
lblError.Text = "No Details Available";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Leave_Summary"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <param name="ViewDetails">The view details.</param>
/// <remarks></remarks>
public Leave_Summary(string EmpId, string EmpName, string ViewDetails, string locallocationType)
{
InitializeComponent();
localEmpId = EmpId;
lblExName.Text = EmpName;
localEmpName = EmpName;
localLeaveDetails = ViewDetails;
locationtype = locallocationType;
// lblUpdatedDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblUpdatedDate.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
dsTotalLeaves = GC.ExcelConnectivity("select * from [Sheet1$] where [Emp No]=" + EmpId + " and [Leave Type]='" + ViewDetails + "'", "OleDbConnString_LeaveRecords_" + "" + locationtype + "");
if (dsTotalLeaves.Tables[0].Rows.Count > 0)
{
dGVLeaveSummary.AutoGenerateColumns = true;
bindingSource1.DataSource = dsTotalLeaves.Tables[0];
dGVLeaveSummary.DataSource = bindingSource1;
LblLeaveType.Visible = true;
LblLeaveType.Text = ViewDetails;
}
else
{
pnlLeaveSummary.Visible = false;
lblLeaveREC.Visible = true;
lblLeaveREC.Text = "No Details Available";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
pnlLeaveSummary.Visible = false;
lblLeaveREC.Visible = true;
lblLeaveREC.Text = "No Details Available";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Total_Leaves_Per_Month"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <remarks></remarks>
public Total_Leaves_Per_Month(string EmpId, string EmpName, string locallocationtype)
{
InitializeComponent();
localEmpId = EmpId;
lblExName.Text = EmpName;
localEmpName = EmpName;
locationtype = locallocationtype;
// lbl_Date.Text = DateTime.Now.ToString("dd-MM-yyyy");
lbl_Date.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
/*emp details sheet connection */
dsTotalLeaves = GC.ExcelConnectivity("Select * from [Sheet1$] where [Emp No]=" + EmpId + "", "OleDbConnString_TotalLeaves_" + "" + locationtype + "");
if (dsTotalLeaves.Tables[0].Rows.Count > 0)
{
/* binding data from empdetails to get user name*/
GrdvwTotalLeaveRecords.AutoGenerateColumns = true;
bindingSource1.DataSource = dsTotalLeaves.Tables[0];
GrdvwTotalLeaveRecords.DataSource = bindingSource1;
}
else
{
pnlTotalLeave.Visible = false;
lbl_Error.Visible = true;
lbl_Error.Text = "No Details Available";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
lbl_Error.Visible = true;
lbl_Error.Text = "No Details Available";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Loss_Of_Pay_Summary"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <remarks></remarks>
public Loss_Of_Pay_Summary(string EmpId, string EmpName, string LOPMonth, string locallocationtype)
{
InitializeComponent();
LocalEmpId = EmpId;
LocalEmpName = EmpName;
lblExName.Text = EmpName;
LocalLOPMonth = LOPMonth;
locationtype = locallocationtype;
// lblupdateddate.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblupdateddate.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
/*Query For Geting Data from Excel Sheet */
dsLOPS = GC.ExcelConnectivity("select [ LOP Dates] from [LOP_Summary$] where [Emp No]='" + EmpId + "' and [Month]='" + LOPMonth + "'", "OleDbConnString_LossOfPay_" + "" + locationtype + "");
if (dsLOPS.Tables[0].Rows.Count > 0)
{
dataGridView1.AutoGenerateColumns = true;
bindingSource1.DataSource = dsLOPS.Tables[0];
dataGridView1.DataSource = bindingSource1;
}
else
{
lbl_Error.Visible = true;
lbl_Error.Text = "No Details Available";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
lbl_Error.Text = "No Details Available";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Loan_Statement"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <param name="LoanType">Type of the loan.</param>
/// <remarks></remarks>
public Loan_Statement(string EmpId, string EmpName, string LoanType, string locallocationType)
{
InitializeComponent();
locationType = locallocationType;
localEmpId = EmpId;
localEmpName = EmpName;
lblEname.Text = EmpName;
localLoanType = LoanType;
if (LoanType == "9HLA")
{
lblLoantype.Text = "HOUSING LOAN";
}
else if (LoanType == "9PFN")
{
lblLoantype.Text = "PF LOAN";
}
else if (LoanType == "9VEH")
{
lblLoantype.Text = "VEHICLE LOAN";
}
else if (LoanType == "9FES")
{
lblLoantype.Text = "FESTIVE ADVANCE";
}
else if (LoanType == "9SAD")
{
lblLoantype.Text = "SALARY ADVANCE";
}
else
{
lblLoantype.Text = "BENEVOLENT LOAN";
}
//lblDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblDate.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
// dsLoanStmt = GC.ExcelConnectivity("Select * from [LoanFullDetails$] where [Emp No] ='" + EmpId + "' and [Loan Type] = '" + localLoanType + "'", "OleDbConnString_Loan_FullDetails");
dsLoanStmt = GC.ExcelConnectivity("Select * from [Sheet1$] where [Emp No] =" + EmpId + " and [Wage Type] = '" + LoanType + "'", "OleDbConnString_LoanDetails");
//retrieving data from LoanFull Details sheet
if (dsLoanStmt.Tables[0].Rows.Count > 0)
{
lblOpeningBal.Text = dsLoanStmt.Tables[0].Rows[0]["Loan Amount"].ToString();
lblLoanRecieved.Text = (Convert.ToDouble(dsLoanStmt.Tables[0].Rows[0]["Loan Amount"]) - Convert.ToDouble(dsLoanStmt.Tables[0].Rows[0]["Loan Balance"])).ToString();
lblClosingBal.Text = dsLoanStmt.Tables[0].Rows[0]["Loan Balance"].ToString();
}
else
{
lblerror.Visible = true;
panelloanstmt.Hide();
lblerror.Text = "No Loans Availed";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
lblerror.Text = "No Loans Availed";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Loan_Balance"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <param name="LoanType">Type of the loan.</param>
/// <remarks></remarks>
public Loan_Balance(string EmpId, string EmpName, string LoanType, string locallocationtype)
{
InitializeComponent();
localEmpId = EmpId;
localEmpName = EmpName;
lblEmpName.Text = EmpName;
localLoan = LoanType;
if (LoanType == "9HLA")
{
lblloanType.Text = "HOUSING LOAN";
}
else if (LoanType == "9PFN")
{
lblloanType.Text = "PF LOAN";
}
else if (LoanType == "9VEH")
{
lblloanType.Text = "VEHICLE LOAN";
}
else if (LoanType == "9FES")
{
lblloanType.Text = "FESTIVE ADVANCE";
}
else if (LoanType == "9SAD")
{
lblloanType.Text = "SALARY ADVANCE";
}
else
{
lblloanType.Text = "BENEVOLENT LOAN";
}
locationtype = locallocationtype;
// lblDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblDate.Text = ConfigurationManager.AppSettings.Get("LastUpdatedDate");
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
// dsClosingbal = GC.ExcelConnectivity("select * from [LoanFullDetails$] where [Emp No] = '" + EmpId + "' and [Loan Type]= '" + LoanType + "'", "OleDbConnString_Loan_FullDetails");
dsClosingbal = GC.ExcelConnectivity("Select * from [Sheet1$] where [Emp No]= " + localEmpId + " and [Wage Type] = '" + localLoan + "'", "OleDbConnString_LoanDetails");
//retrieving closing amount from LoanFullDetails sheet
if (dsClosingbal.Tables[0].Rows.Count > 0)
{
// lblAmtClosingDate.Text = System.DateTime.Now.ToShortDateString();
lblLoanBalance.Text = "Your Loan Balance as on date " + ConfigurationManager.AppSettings.Get("LastUpdatedDate") + " is " + dsClosingbal.Tables[0].Rows[0]["Loan Balance"].ToString() + "";
}
else
{
lblLoanBalance.Visible = false;
lblerror.Visible = true;
lblerror.Text = "No Loans Availed";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
lblerror.Text = "No Loans Availed";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="LoanDetails_Brief"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <param name="LoanType">Type of the loan.</param>
/// <remarks></remarks>
public LoanDetails_Brief(string EmpId, string EmpName, string LoanType, string locallocationType)
{
InitializeComponent();
locationType = locallocationType;
LocalEmpId = EmpId;
localEmpName = EmpName;
lblEmpName.Text = EmpName;
localLoanType = LoanType;
if (LoanType == "9HLA")
{
lblLoanType.Text = "HOUSING LOAN";
}
else if (LoanType == "9PFN")
{
lblLoanType.Text = "PF LOAN";
}
else if (LoanType == "9VEH")
{
lblLoanType.Text = "VEHICLE LOAN";
}
else if (LoanType == "9FES")
{
lblLoanType.Text = "FESTIVE ADVANCE";
}
else if (LoanType == "9SAD")
{
lblLoanType.Text = "SALARY ADVANCE";
}
else
{
lblLoanType.Text = "BENEVOLENT LOAN";
}
// lblDt.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblDt.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
dsLoanDetails = GC.ExcelConnectivity("Select * from [Sheet1$] where [Emp No] =" + EmpId + " and [Wage Type] = '" + localLoanType + "'", "OleDbConnString_LoanDetails");
//retrieving data from LoanDetails sheet
if (dsLoanDetails.Tables[0].Rows.Count > 0)
{
pnlLOP.Visible = true;
dgvLoan.Visible = true;
dgvLoan.AutoGenerateColumns = true;
bindingSource1.DataSource = dsLoanDetails.Tables[0];
dgvLoan.DataSource = bindingSource1;
// lblLoanTknAmt.Text = Convert.ToDateTime( dsLoanDetails.Tables[0].Rows[0]["Loan Taken Date"].ToString()).ToShortDateString();
// lblLoanAmt.Text = dsLoanDetails.Tables[0].Rows[0]["Loan Amount"].ToString();
//lblInterest.Text = dsLoanDetails.Tables[0].Rows[0]["Interest Percent"].ToString();
//// lblNoofInstnts.Text = dsLoanDetails.Tables[0].Rows[0]["No of Installments"].ToString(); //appending data to the controls
// lblMonthlyEmi.Text = dsLoanDetails.Tables[0].Rows[0]["Monthly EMI"].ToString();
//// lblLoanRecovry.Text = dsLoanDetails.Tables[0].Rows[0]["Loan Recovery"].ToString();
}
else
{
pnlLOP.Visible = false;
dgvLoan.Visible = false;
lblerror.Visible = true;
lblerror.Text = "No Loans Availed";
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
pnlLOP.Visible = false;
dgvLoan.Visible = false;
lblerror.Visible = true;
lblerror.Text = "No Loans Availed";
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Medical_Expences"/> class.
/// </summary>
/// <param name="EmpId">The emp id.</param>
/// <param name="EmpName">Name of the emp.</param>
/// <remarks></remarks>
public Medical_Expences(string EmpId, string EmpName, string locallocationType)
{
InitializeComponent();
LocalEmpId = EmpId;
lblExName.Text = EmpName;
localEmpName = EmpName;
locationType = locallocationType;
int i;
double BalanceSum = 0;
// lblUpdatedDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
lblUpdatedDate.Text = ConfigurationManager.AppSettings["LastUpdatedDate"];
try
{
_am.WarningMinutes = Convert.ToDouble(ConfigurationManager.AppSettings["WarningMinutes"]);
_am.MaxMinutesIdle = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMinutesIdle"]);
_am.Idle += new EventHandler(am_Idle);
activityMonitorBindingSource.DataSource = _am;
}
catch
{
}
try
{
dsMedicalExp = GC.ExcelConnectivity("select * from [Sheet1$] where [Emp No]='" + EmpId + "'", "OleDbConnString_Medical_Expences_" + "" + locationType + "");
if (dsMedicalExp.Tables[0].Rows.Count > 0)
{
dGVMedicalExpences.AutoGenerateColumns = true;
lblTotalEligibleAmount.Text = dsMedicalExp.Tables[0].Rows[0]["Eligible Amount"].ToString() + " as on " + dsMedicalExp.Tables[0].Rows[0]["Eligible Amount Date"].ToString();
lblAvailbleBalance.Text = dsMedicalExp.Tables[0].Rows[0]["Balance"].ToString();
bindingSource1.DataSource = dsMedicalExp.Tables[0];
dGVMedicalExpences.DataSource = bindingSource1;
this.dGVMedicalExpences.Columns["Eligible Amount"].Visible = false;
this.dGVMedicalExpences.Columns["Eligible Amount Date"].Visible = false;
this.dGVMedicalExpences.Columns["Balance"].Visible = false;
this.dGVMedicalExpences.Columns["Emp No"].Visible = false;
this.dGVMedicalExpences.Columns["Payroll Area"].Visible = false;
}
else
{
pnlMedicalExp.Visible = false;
lblError.Visible = true;
lblError.Text = "No Data Available";
lblAvailBal.Visible = false;
lblAvailbleBalance.Visible = false;
lblTotalEligibleAmount.Visible = false;
lblTotEligibleAmt.Visible = false;
}
}
catch (Exception ex)
{
GC.ErrorLoging(ex.ToString());
pnlMedicalExp.Visible = false;
lblError.Visible = true;
lblError.Text = "No Data Available";
lblAvailBal.Visible = false;
lblAvailbleBalance.Visible = false;
lblTotalEligibleAmount.Visible = false;
lblTotEligibleAmt.Visible = false;
}
}
