private void setData(string start_date, string end_date)
{
rayan_sportDataSet.logDataTable logDataTable = new rayan_sportDataSet.logDataTable();
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
logTableAdapter.FillBySelectLogByDate(logDataTable, start_date, end_date);
dgv_UcShowMemberContractInfoContracts.DataSource = logDataTable;
}
private void btn_UcSettingConfirm_Click(object sender, EventArgs e)
{
date = getDateShamsi(DateTime.Now.ToString("M/d/yyyy"));
time = DateTime.Now.ToShortTimeString().ToString();
targetTable = "log";
rayan_sportDataSet.logDataTable logDataTable = new rayan_sportDataSet.logDataTable();
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
logTableAdapter.InsertChengePassLog("Chenge Pass From" + oldPassword + "To" + newPassword, targetTable, username, date, time);
oldPassword = txb_UcSettingOldPass.Text;
newPassword = txb_UcSettingnewPass.Text;
confirmPassword = txb_UcSettingrepeatPass.Text;
if (txb_UcSettingOldPass.Text == "" || txb_UcSettingnewPass.Text == "" || txb_UcSettingrepeatPass.Text == "")
{
Alert alert2 = new Alert("اطلاعات را به صورت کامل وارد کنید ", "red");
}
else if (txb_UcSettingOldPass.Text != "" && txb_UcSettingnewPass.Text != "" && txb_UcSettingrepeatPass.Text != "")
{
oldPassword = txb_UcSettingOldPass.Text;
newPassword = txb_UcSettingnewPass.Text;
confirmPassword = txb_UcSettingrepeatPass.Text;
oldPassword = hashPass(oldPassword);
hashNewPassword = hashPass(newPassword);
rayan_sportDataSet.userDataTable dataTable = new rayan_sportDataSet.userDataTable();
rayan_sportDataSetTableAdapters.userTableAdapter adapter = new rayan_sportDataSetTableAdapters.userTableAdapter();
adapter.UpdatePassword(newPassword, hashNewPassword, oldPassword);
Alert alert = new Alert("گذرواژه با موفقیت تغییر یافت", "blue");
//SqlConnection conn = new SqlConnection("Data Source = 169.254.92.252; " +
// "Initial Catalog=rayan_Attendance;" +
// "User id=test; " +
// "Password=HoseinNima1234;");
//conn.Open();
//SqlCommand sc = new SqlCommand();
//sc.CommandType = CommandType.Text;
//sc.Connection = conn;
//SqlDataReader reader;
//SqlTransaction transaction;
//transaction = conn.BeginTransaction("new");
//sc.Transaction = transaction;
//try
//{
// sc.CommandText = "SELECT id FROM Users WHERE username = '******' AND password = '******'";
// sc.ExecuteNonQuery();
// reader = sc.ExecuteReader();
// if (reader.HasRows)
// {
// reader.Read();
// id = reader.GetInt64(0);
// }
// reader.Close();
// if (newPassword == confirmPassword)
// {
// sc.CommandText = "UPDATE Users SET password = '******'";
// sc.ExecuteNonQuery();
// MessageBox.Show("تغییر گذرواژه انجام شد");
// }
// else
// {
// MessageBox.Show("گذرواژه و تایید گذرواژه یکسان نیست");
// }
// transaction.Commit();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
}
