/// <summary>
        ///  This is button click event and inserts new saleman on submit click.
        /// </summary>
        /// <param name="sender">sender Object.</param>
        /// <param name="e">evnet arg.</param>
        protected void SubmitBtn_Click(object sender, EventArgs e)
        {
            int        rowInserted = 0;
            SalesmanBO newSalesman = new SalesmanBO()
            {
                Id         = Convert.ToInt32(this.SalesmanIdTxt.Text),
                Name       = this.SalesmanNameTxt.Text,
                City       = this.SalesmanCityTxt.Text,
                Commission = Convert.ToDecimal(this.SalesmanCommissionTxt.Text),
            };

            SalesmanBL newSalesmanBL = new SalesmanBL();

            rowInserted = newSalesmanBL.InsertSalesman(newSalesman);

            if (rowInserted > 0)
            {
                Console.WriteLine($"Total {rowInserted} Row(s) Affected ");
            }

            this.SalesmanIdTxt.Text         = string.Empty;
            this.SalesmanNameTxt.Text       = string.Empty;
            this.SalesmanCityTxt.Text       = string.Empty;
            this.SalesmanCommissionTxt.Text = string.Empty;
            this.SalesmanIdTxt.Focus();

            this.SalesmanGv.DataSource = newSalesmanBL.GridViewBind();
            this.SalesmanGv.DataBind();
        }
        /// <summary>
        /// this is pageload event.
        /// </summary>
        /// <param name="sender">sender object.</param>
        /// <param name="e">Event Args.</param>
        protected void Page_Load(object sender, EventArgs e)
        {
            SalesmanBL newSalesmanBL = new SalesmanBL();

            if (!this.Page.IsPostBack)
            {
                this.SalesmanGv.Columns[0].HeaderText = "ID";
                this.SalesmanGv.Columns[1].HeaderText = "Name";
                this.SalesmanGv.Columns[2].HeaderText = "City";
                this.SalesmanGv.Columns[3].HeaderText = "Commission";
                this.SalesmanGv.DataSource            = newSalesmanBL.GridViewBind();
                this.SalesmanGv.DataBind();
            }
        }