protected void AddAdminDetails_Click(object sender, EventArgs e)
        {
            try
            {
                string RandomPassword = Path.GetRandomFileName();
                RandomPassword = RandomPassword.Replace(".", "");

                NasaFitnessDbDataContext nasaFitnessDbDataContext = new NasaFitnessDbDataContext
                                                                        ("Server=tcp:nasafitness.database.windows.net,1433;Initial Catalog=nasafitnessllc;Persist Security Info=False;User ID=dr_nasafitness;Password=Conversion2016;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");

                nasafitness nasafitness = new nasafitness
                {
                    user_name        = AdminName.Text,
                    company_name     = CompanyName.Text,
                    position         = Position.SelectedValue,
                    email_id         = EmailID.Text,
                    pass_word        = RandomPassword,
                    administrator    = 0,
                    company_location = CompanyLocation.Text
                };

                company_detail company_Detail = new company_detail
                {
                    company_name  = CompanyName.Text,
                    location_name = CompanyLocation.Text
                };

                nasaFitnessDbDataContext.company_details.InsertOnSubmit(company_Detail);
                nasaFitnessDbDataContext.nasafitnesses.InsertOnSubmit(nasafitness);
                nasaFitnessDbDataContext.SubmitChanges();
                nasaFitnessDbDataContext.Dispose();

                // Creates a MailMessage
                MailMessage mail = new MailMessage("*****@*****.**", EmailID.Text);
                mail.Subject = "Auto Generated Reply from NasaFitness";
                mail.Body    = $"You are now successfully added as Admin with password : {RandomPassword}";

                // Username and Password of Sender
                SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587);
                smtpClient.Credentials = new NetworkCredential("*****@*****.**", "sandhya3654");
                smtpClient.EnableSsl   = true;
                smtpClient.Send(mail);

                AdminDetailsMessage.Visible = true;
            }
            catch (Exception ex)
            {
            }
        }
        protected void AddLocation_Click(object sender, EventArgs e)
        {
            NasaFitnessDbDataContext nasaFitnessDbDataContext = new NasaFitnessDbDataContext
                                                                    ("Server=tcp:nasafitness.database.windows.net,1433;Initial Catalog=nasafitnessllc;Persist Security Info=False;User ID=dr_nasafitness;Password=Conversion2016;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");

            company_detail company_Detail = new company_detail
            {
                location_name = Location.Text,
            };

            nasaFitnessDbDataContext.company_details.InsertOnSubmit(company_Detail);
            nasaFitnessDbDataContext.SubmitChanges();

            nasaFitnessDbDataContext.Dispose();
            Message.Text    = "Company added successfully";
            Message.Visible = true;
        }
 partial void Updatecompany_detail(company_detail instance);
 partial void Deletecompany_detail(company_detail instance);
 partial void Insertcompany_detail(company_detail instance);