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 ChangePasswordButton_Click(object sender, EventArgs e)
{
var username = Session["username"].ToString();
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;");
var entity = nasaFitnessDbDataContext.nasafitnesses.Where(m => m.user_name == username).SingleOrDefault();
if (entity is null)
{
Response.Write("<script>alert('User does not Exist.')</script>");
}
else
{
if (entity.pass_word.Equals(OldPassword.Text))
{
if (ConfirmPassword.Text.Equals(CurrentPassword.Text))
{
nasafitness result = (from p in nasaFitnessDbDataContext.nasafitnesses
where p.pass_word == OldPassword.Text
select p).SingleOrDefault();
result.pass_word = CurrentPassword.Text;
nasaFitnessDbDataContext.SubmitChanges();
Response.Write("<script>alert('Password Changes Successfully.')</script>");
}
else
{
Response.Write("<script>alert('Old and New Password does not Match.')</script>");
}
}
else
{
Response.Write("<script>alert('Old Password is Invalid.')</script>");
}
}
nasaFitnessDbDataContext.Dispose();
}
partial void Deletenasafitness(nasafitness instance);
partial void Updatenasafitness(nasafitness instance);
partial void Insertnasafitness(nasafitness instance);
