protected void btnSerial_Click(object sender, EventArgs e)
        {
            string  Doctor_ID   = Request.QueryString["Did"].ToString();
            string  Schedul_ID  = Request.QueryString["Sid"].ToString();
            string  Serial_Date = Request.QueryString["d"].ToString();
            Check   chk         = new Check();
            Decrypt de          = new Decrypt();

            Serial_Date = Serial_Date.Replace(" ", "+");
            Serial_Date = de.GetDecryptHashCode(Serial_Date);
            if (Serial_Date != "error" && chk.int32Check("select count(*) from DoctorRegistation where DoctorID='" + Doctor_ID + "'") == 1 && chk.int32Check("select count(*) from Schedul where ID=" + Schedul_ID) == 1)
            {
                var st = " from DoctorRegistation where DoctorID='" + Doctor_ID + "'";

                string Schdul_Payment       = chk.stringCheck("select Payment from Schedul where ID=" + Schedul_ID);
                string Schdul_Payment_Title = "";

                int Schdul_Price     = chk.int32Check("select Fee from Schedul where ID=" + Schedul_ID);
                int Additional_Price = chk.int32Check("select Taka from Normal_Serial_Price where ID=1");
                int Vat      = chk.int32Check("select Taka from Normal_Serial_Price where ID=2");
                int Discount = chk.int32Check("select Discount from Schedul where ID=" + Schedul_ID);

                int    total         = 0;
                double Vat_Taka      = 0;
                double Discount_Taka = 0;

                if (Schdul_Payment == "TRUE")
                {
                    Schdul_Payment_Title = "Payfast";
                    int    Total_Taka = Schdul_Price;// main taka
                    double main_Price = Schdul_Price;
                    double d          = (main_Price * Discount);
                    Discount_Taka = (int)Math.Ceiling(d / 100);
                    main_Price   -= Discount_Taka;// main price - disount price
                    double v = (main_Price * Vat);
                    Vat_Taka    = (int)Math.Ceiling(v / 100);
                    main_Price += Vat_Taka;
                    total       = (int)Math.Ceiling(Additional_Price + main_Price);
                }
                else
                {
                    Schdul_Payment_Title = "Pay in Doctor";
                    int    Total_Taka = Schdul_Price;// main taka
                    double main_Price = Schdul_Price;
                    double d          = (main_Price * Discount);
                    Discount_Taka = (int)Math.Ceiling(d / 100);
                    main_Price   -= Discount_Taka;// main price - disount price
                    double v = (main_Price * Vat);
                    Vat_Taka    = (int)Math.Ceiling(v / 100);
                    main_Price += Vat_Taka;
                    total       = (int)Math.Ceiling(Additional_Price + main_Price);
                    total      -= (int)(Schdul_Price - Discount_Taka);
                }
                if (total == 0)
                {
                    //ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('ok');", true);
                    if (Session["UserName"] != null && Session["UserImage"] != null && Session["UserID"] != null)
                    {
                        // --------------------- login person -----------------------
                    }
                    else
                    {
                        if (txtEmail.Text != "" && txtMobileNo.Text != "" && txtPatientName.Text != "" && ddlDistrict.SelectedValue != "0" && ddlDivision.SelectedValue != "0" && ddlUpazila.SelectedValue != "0")
                        {
                            SqlCommand cmd = new SqlCommand();
                            cmd.Connection  = con;
                            cmd.CommandText = @"insert into Serial (SerialID,DoctorID,SchedulID,PatientName,UserOrNot,Email,MobileNo,Division,District,Upazila,Payment_T_F,OriginalPrice,SerialPrice,AdditionalPrice,DiscountPercentage,DicountTaka,VatPercentage,VatTaka,Total,SerialDate,SubmitDate,SerialActive,PaymentClear)
                            values (@SerialID,@DoctorID,@SchedulID,@PatientName,@UserOrNot,@Email,@MobileNo,@Division,@District,@Upazila,@Payment_T_F,@OriginalPrice,@SerialPrice,@AdditionalPrice,@DiscountPercentage,@DicountTaka,@VatPercentage,@VatTaka,@Total,@SerialDate,@SubmitDate,@SerialActive,@PaymentClear)";
                            RandomNumberGenarator rn = new RandomNumberGenarator();
                            rn.ResultDate = chk.int32Check("select Taka from Normal_Serial_Price where ID=4");
                            string Ser = rn.RandomStringNumber("Normal_Serial_ID");
                            cmd.Parameters.AddWithValue("@SerialID", Ser);
                            cmd.Parameters.AddWithValue("@DoctorID", Doctor_ID);
                            cmd.Parameters.AddWithValue("@SchedulID", Schedul_ID);
                            cmd.Parameters.AddWithValue("@PatientName", txtPatientName.Text);
                            cmd.Parameters.AddWithValue("@UserOrNot", "FALSE");
                            cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
                            cmd.Parameters.AddWithValue("@MobileNo", txtMobileNo.Text);
                            cmd.Parameters.AddWithValue("@Division", ddlDivision.SelectedItem.ToString());
                            cmd.Parameters.AddWithValue("@District", ddlDistrict.SelectedItem.ToString());
                            cmd.Parameters.AddWithValue("@Upazila", ddlUpazila.SelectedItem.ToString());
                            cmd.Parameters.AddWithValue("@Payment_T_F", "FALSE");
                            cmd.Parameters.AddWithValue("@OriginalPrice", Convert.ToInt32(Schdul_Price));
                            cmd.Parameters.AddWithValue("@SerialPrice", Convert.ToInt32(Schdul_Price - Discount_Taka));
                            cmd.Parameters.AddWithValue("@AdditionalPrice", Convert.ToInt32(Additional_Price));
                            cmd.Parameters.AddWithValue("@DiscountPercentage", Convert.ToInt32(Discount));
                            cmd.Parameters.AddWithValue("@DicountTaka", Convert.ToInt32(Discount_Taka));
                            cmd.Parameters.AddWithValue("@VatPercentage", Convert.ToInt32(Vat));
                            cmd.Parameters.AddWithValue("@VatTaka", Convert.ToInt32(Vat_Taka));
                            cmd.Parameters.AddWithValue("@Total", Convert.ToInt32(total));
                            cmd.Parameters.AddWithValue("@SerialDate", Serial_Date);
                            cmd.Parameters.AddWithValue("@SubmitDate", DateTime.Now.ToString("MM/dd/yyyy"));
                            cmd.Parameters.AddWithValue("@SerialActive", "FALSE");
                            cmd.Parameters.AddWithValue("@PaymentClear", "FALSE");
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                            Session["Serial_ID"]        = Ser;
                            Session["Serial_Date"]      = Serial_Date;
                            Session["Schedul_ID"]       = Schedul_ID;
                            Session["Serial_Doctor_ID"] = Doctor_ID;

                            string Time   = chk.stringCheck("select FastTime from Schedul where ID=" + Schedul_ID) + "-" + chk.stringCheck("select LastTime from Schedul where ID=" + Schedul_ID);
                            string STitle = chk.stringCheck("select Title from Schedul where ID=" + Schedul_ID);
                            mail   m      = new mail();
                            m.SendMail(txtEmail.Text, "Doctor Serial", "Sucessfully. (Doctor Serial ID: " + Ser + " Serial Date: " + Serial_Date + ") (" + STitle + ") Time: " + Time + ". Please Come 30 min Fast in serial Time.");
                            Response.Redirect("congratulations");
                        }
                        else
                        {
                            lblResult.ForeColor = Color.Red;
                            lblResult.Text      = "      Type Email/ Mobile No/ Patient Name..";
                        }
                    }
                }
                else
                {// payment option
                    if (Session["UserName"] != null && Session["UserImage"] != null && Session["UserID"] != null)
                    {
                        if (txtPatientName_Auto.Text != "")
                        {
                            string PaymentOption = "";
                            if (RBBank.Checked == true)
                            {
                                PaymentOption = "Bank";
                            }
                            else if (RBbkash.Checked == true)
                            {
                                PaymentOption = "Bkash";
                            }
                            else if (RBMasterCard.Checked == true)
                            {
                                PaymentOption = "MasterCard";
                            }
                            else if (RBPaypal.Checked == true)
                            {
                                PaymentOption = "Paypal";
                            }
                            else if (RBRocket.Checked == true)
                            {
                                PaymentOption = "Rocket";
                            }
                            else if (RBVisa.Checked == true)
                            {
                                PaymentOption = "Visa";
                            }
                            else
                            {
                                ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Select Payment Mathord.');", true);
                                lblResult.Text = "Select Payment Mathord.";
                            }
                            if (PaymentOption != "")
                            {
                                Response.Redirect("Payment/?opt=" + PaymentOption);
                            }
                        }
                        else
                        {
                            ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Type Patient Name.');", true);
                            lblResult.Text = "Type Patient Name.";
                        }
                    }
                    else
                    {
                        if (txtEmail.Text != "" && txtMobileNo.Text != "" && txtPatientName.Text != "" && ddlDistrict.SelectedValue != "0" && ddlDivision.SelectedValue != "0" && ddlUpazila.SelectedValue != "0")
                        {
                            string PaymentOption = "";
                            if (RBBank.Checked == true)
                            {
                                PaymentOption = "Bank";
                            }
                            else if (RBbkash.Checked == true)
                            {
                                PaymentOption = "Bkash";
                            }
                            else if (RBMasterCard.Checked == true)
                            {
                                PaymentOption = "MasterCard";
                            }
                            else if (RBPaypal.Checked == true)
                            {
                                PaymentOption = "Paypal";
                            }
                            else if (RBRocket.Checked == true)
                            {
                                PaymentOption = "Rocket";
                            }
                            else if (RBVisa.Checked == true)
                            {
                                PaymentOption = "Visa";
                            }
                            else
                            {
                                ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Select Payment Mathord.');", true);
                                lblResult.Text = "Select Payment Mathord.";
                            }
                            if (PaymentOption != "")
                            {
                                Response.Redirect("Payment/?opt=" + PaymentOption);
                            }
                        }
                        else
                        {
                            ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Type Full Details for Patient.');", true);
                            lblResult.Text = "Type Full Details for Patient.";
                        }
                    }
                }
            }
            else
            {
                Response.Redirect(Error_Page);
            }
        }