protected void BindBillGridview()
 {
     try
     {
         DataTable dtPhoneBillDetails = TMSTelephoneBillDetails.BindTelePhoneBillDetails(Convert.ToInt64(Session["UserId"]), null, null, null, null).Tables[0];
         if (dtPhoneBillDetails.Rows.Count > 0)
         {
             grdBillDetails.DataSource = dtPhoneBillDetails;
             grdBillDetails.DataBind();
         }
         else
         {
             grdBillDetails.DataSource = null;
             grdBillDetails.DataBind();
         }
     }
     catch (Exception ex) { }
 }
    private void BindPopUp(string MonthName, string Type)
    {
        try
        {
            string Month    = MonthName;
            string DeptName = Type;

            DataTable dtBillDetails = TMSTelephoneBillDetails.BindTelePhoneBillDetails(Convert.ToInt64(Session["UserId"]), null, Month, ddlYear1.SelectedValue, DeptName).Tables[0];
            if (dtBillDetails.Rows.Count > 0)
            {
                lstPhone.DataSource = dtBillDetails;
                lstPhone.DataBind();
            }
            else
            {
                lstPhone.DataSource = null;
                lstPhone.DataBind();
            }
        }
        catch (Exception ex) { }
    }