예제 #1
0
    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();
    }
예제 #2
0
    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) { }
    }