public ActionResult Index(AkunModel akun)
{
DataTable datatbl = new DataTable();
using (SqlConnection sqlcon = new SqlConnection(connectionString))
{
sqlcon.Open();
string query = "SELECT * FROM akun WHERE email = @email AND password= @password";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlcon);
sqlDa.SelectCommand.Parameters.AddWithValue("@email", akun.email);
sqlDa.SelectCommand.Parameters.AddWithValue("@password", akun.password);
sqlDa.Fill(datatbl);
}
if (datatbl.Rows.Count == 1)
{
Session["id"] = datatbl.Rows[0]["id_akun"];
Session["nama"] = datatbl.Rows[0]["nama_akun"];
return(RedirectToAction("Dashboardv1", "Dashboard"));
}
return(RedirectToAction("Index", "Login"));
}
private void viewAccountProfileToolStripMenuItem_Click(object sender, EventArgs e)
{
using (var db = new AkunModel())
{
var result = db.Akun.SingleOrDefault(a => a.Username == lblUsername.Text);
if (result != null)
{
ProfilAkun profilAkun = new ProfilAkun(result.Username, result.Umur, result.Gender, result.Kondisi);
profilAkun.ShowDialog();
}
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
using (var db = new AkunModel())
{
var result = db.Akun.SingleOrDefault(a => a.Username == lblUsername.Text);
if (result != null)
{
result.Poin = int.Parse(lblSkor.Text);
result.Kondisi = lblKeterangan.Text;
db.SaveChanges();
MessageBox.Show("Data tersimpan!");
}
}
}
private void DaftarAkun()
{
if (tbNama.Text != "" && tbUmur.Text != "" && tbPassword.Text != "" && tbKonfirmasiPass.Text != "")
{
if (tbPassword.Text.Length > 8)
{
if (tbPassword.Text == tbKonfirmasiPass.Text)
{
using (var db = new AkunModel())
{
string jenisKelamin;
if (rbLaki.Checked)
{
jenisKelamin = "Laki-laki";
}
else
{
jenisKelamin = "Perempuan";
}
Akun newAkun = new Akun
{
Username = tbNama.Text,
Umur = Convert.ToInt32(tbUmur.Text),
Gender = jenisKelamin,
Password = tbPassword.Text,
};
db.Akun.Add(newAkun);
db.SaveChanges();
MessageBox.Show("Akun terdaftar");
Close();
}
}
else
{
MessageBox.Show("Password tidak sama");
}
}
else
{
MessageBox.Show("Password harus lebih dari 8 karalter");
}
}
else
{
MessageBox.Show("Data harus diisi lengkap!");
}
}
private void deleteAccountToolStripMenuItem_Click(object sender, EventArgs e)
{
using (var db = new AkunModel())
{
db.Akun.RemoveRange(db.Akun.Where(item => item.Username == lblUsername.Text));
db.SaveChanges();
lblUsername.Text = "(UserName)";
lblGender.Text = "-";
lblUmur.Text = "-";
btnCekKondisi.Enabled = false;
btnPsikolog.Enabled = false;
btnLogin.Visible = true;
lblLogin.Visible = true;
}
loginForm.isCorrect = false;
MessageBox.Show("Akun Telah Dihapus");
}
private void btnLogin_Click(object sender, EventArgs e)
{
loginForm.ShowDialog();
using (var db = new AkunModel())
{
var result = db.Akun.SingleOrDefault(a => a.Username == loginForm.tbNama.Text);
if (loginForm.isCorrect)
{
lblUsername.Text = result.Username;
lblUmur.Text = result.Umur + " tahun";
lblGender.Text = result.Gender;
btnCekKondisi.Enabled = true;
lblLogin.Visible = false;
btnLogin.Visible = false;
}
}
}
public void Login(string _nama, string _password)
{
using (var db = new AkunModel())
{
var result = from akun in db.Akun where akun.Username == _nama select akun;
foreach (var item in result)
{
if (_nama == item.Username && _password == item.Password)
{
isCorrect = true;
}
else
{
isCorrect = false;
}
}
}
}
private void editAccountToolStripMenuItem_Click(object sender, EventArgs e)
{
using (var db = new AkunModel())
{
var query = from akun in db.Akun where akun.Username == lblUsername.Text select akun;
foreach (var item in query)
{
DaftarAkunForm daftarAkunForm = new DaftarAkunForm(item.Username, item.Umur, item.Password, item.Gender);
daftarAkunForm.ShowDialog();
lblUsername.Text = daftarAkunForm.tbNama.Text;
lblUmur.Text = daftarAkunForm.tbUmur.Text + " tahun";
if (daftarAkunForm.rbLaki.Checked)
{
lblGender.Text = "Laki-laki";
}
else
{
lblGender.Text = "Perempuan";
}
btnCekKondisi.Enabled = true;
}
}
}
private void EditAkun()
{
using (var db = new AkunModel())
{
var result = db.Akun.SingleOrDefault(a => a.Username == akun.Username);
if (result != null)
{
if (tbNama.Text != "" && tbUmur.Text != "" && tbPassword.Text != "" && tbKonfirmasiPass.Text != "")
{
if (PasswordCheck(tbPassword.Text, tbKonfirmasiPass.Text))
{
result.Username = tbNama.Text;
result.Umur = Convert.ToInt32(tbUmur.Text);
result.Password = tbPassword.Text;
if (rbLaki.Checked)
{
result.Gender = "Laki-laki";
}
else
{
result.Gender = "Perempuan";
}
db.SaveChanges();
MessageBox.Show("Kontak berhasil diperbarui");
Close();
}
}
else
{
MessageBox.Show("Nama, Alamat, dan Nomor Telepon harus diisi");
}
}
}
}
