protected void FillBusDriverSalaryDetails() { string Month = null; string Year = null; if (ddlMonth.SelectedValue != "-1") { Month = ddlMonth.SelectedValue; } if (ddlYear.SelectedValue != "-1") { Year = ddlYear.SelectedValue; } DataTable dt = TMSBusMaintananceDetails.GetStaffSalaryDetails(null, Convert.ToInt64(Session["UserId"]), "Driver", null, Month, Year, "4").Tables[0]; GriedViewDriver.DataSource = dt; GriedViewDriver.DataBind(); }
protected void lnkViewSalarySlip_Details(object sender, EventArgs e) { try { PanSalarySection.Visible = true; LinkButton lnk = (LinkButton)sender; GridViewRow lml = (GridViewRow)lnk.NamingContainer; Label lblSalaryDetailsId = lml.FindControl("lblsalDetailsId") as Label; DataTable dt = TMSBusMaintananceDetails.GetStaffSalaryDetails(Convert.ToInt64(lblSalaryDetailsId.Text), Convert.ToInt64(Session["UserId"]), "Driver", null, null, null, "4").Tables[0]; // TMSSalaryDetails objSalary = TMSSalaryDetails.Get(SalaryDetailsId); if (dt.Rows.Count > 0) { lblMonthName.Text = dt.Rows[0]["SI_Month"].ToString(); lblYearName.Text = dt.Rows[0]["SI_Year"].ToString(); Decimal GrossSalary = Convert.ToDecimal(dt.Rows[0]["SI_GrossSalary"].ToString()); Decimal DeductionAmt = Convert.ToDecimal(dt.Rows[0]["SI_LeaveDeductionAmount"].ToString()); Decimal NetSal = GrossSalary - DeductionAmt; lblNetSalary.Text = Convert.ToString(NetSal); lblNetSalWord.Text = NumberToWords(Convert.ToInt32(lblNetSalary.Text)).ToUpper(); grdSalarySlip.DataSource = dt; grdSalarySlip.DataBind(); lblEmployeeNmae.Text = Convert.ToString(dt.Rows[0]["BSD_StaffName"].ToString()); lblJoiningDtae.Text = String.Format("{0:dd MMM yyyy}", dt.Rows[0]["BSD_DateOfJoining"]); //lblDept.Text = Convert.ToString(dtFacultyDetails.Rows[0]["FD_SpecificExpertise"]); lblDesignation.Text = Convert.ToString(dt.Rows[0]["BSD_StaffType"]); //lblEmpCode.Text = Convert.ToString(dtFacultyDetails.Rows[0][""]); //lblLocation.Text = Convert.ToString(dtFacultyDetails.Rows[0]["FacultyCity"]); } Control p = lnk.Parent; AjaxControlToolkit.ModalPopupExtender SalarySlipPopUp = (AjaxControlToolkit.ModalPopupExtender)p.FindControl("SalarySlipPopUp"); SalarySlipPopUp.Show(); } catch (Exception ex) { } }