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