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);