protected void FillActiveEMITable()
        {
            try
            {
                activeEMI_dt = order_dt.Clone();
                activeEMI_dt.Columns.Add("EMIduedate", typeof(System.DateTime));
                foreach (DataRow row in order_dt.Rows)
                {
                    if (Convert.ToDecimal(row["balance"]) > 1)
                    {
                        activeEMI_dt.Rows.Add(row.ItemArray);
                    }
                }
                DateTime today = DateTime.Now.Date;
                foreach (DataRow row in activeEMI_dt.Rows)
                {
                    row["EMIduedate"] = new DateTime(today.Year, today.Month + 1, 1).AddDays(-1);
                }

                ActiveEMI_gridview.DataSource = activeEMI_dt;
                ActiveEMI_gridview.DataBind();
            }
            catch (Exception ex)
            {
                string errormessage = ex.Message;
                Response.Write("<script>alert('Error Signing In :" + errormessage + "');</script>");
            }
        }
        protected void MyButtonClick(object sender, System.EventArgs e)
        {
            try
            {
                Button      btn         = (Button)sender;
                GridViewRow selectedRow = (GridViewRow)btn.NamingContainer;

                int       orderid = Convert.ToInt32(selectedRow.Cells[0].Text);
                DataTable dt      = GetOrderSpecificEMI(orderid);
                Response.Write("<script>alert('Fetching details')</script>");
                OrderSpecific_gridview.DataSource = dt;
                OrderSpecific_gridview.DataBind();
                pnlPopup.Visible = true;

                ActiveEMI_gridview.DataBind();
                OrderHistory_gridview.DataBind();
            }
            catch (Exception ex)
            {
                string errormessage = ex.Message;
                Response.Write("<script>alert('Error Fetching Details:" + errormessage + "');</script>");
            }
        }