protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            DataTable dtTest = TMSTelephoneBillDetails.GetSearch(null, Convert.ToInt64(ddlPhone.SelectedValue), ddlMonth.SelectedValue, null, null, null, null, null, null, 1).Tables[0];
            if (dtTest.Rows.Count > 0)
            {
                dvMsg.Visible   = true;
                lblMessage.Text = "Details Are Already added for this Telephone Number!!!";
                dvMsg.Attributes.Add("class", "error_msg");
            }
            else
            {
                TMSTelephoneBillDetails objBill = new TMSTelephoneBillDetails();
                objBill.TBDBillAmount    = Convert.ToInt64(txtBill.Text);
                objBill.TBDMonth         = ddlMonth.SelectedValue;
                objBill.TBDYear          = ddlYear.SelectedValue;
                objBill.TBDTelephoneId   = Convert.ToInt64(ddlPhone.SelectedValue);
                objBill.TBDAddedById     = Convert.ToInt64(Session["UserId"]);
                objBill.TBDDate          = DateTime.Now;
                objBill.TBDAddedByRemark = "Account Manger";
                objBill.TBDStatus        = 1;
                objBill.TBDPaidStatus    = "UnPaid";
                objBill.Insert();
                txtBill.Text    = "";
                dvMsg.Visible   = true;
                lblMessage.Text = "Telephone Bill Details added Successfully!!!";
                dvMsg.Attributes.Add("class", "warring_msg");

                BindBillGridview();
            }
        }
        catch (Exception ex) { }
    }