public editpegawai(Akun ed) { InitializeComponent(); password.Password = ed.Password; EditPegawai.DataContext = ed; akun = ed; }
private void hapeg_Click(object sender, RoutedEventArgs e) { try { if (listselected.Count() > 0) { int count = 0; foreach (int eno in listselected) { Akun emp = (from ep in repo.Get() where ep.IdPegawai == eno select ep).First(); repo.Delete(emp); count++; } MessageBox.Show(count + " Row's Deleted"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } menuadmin aha = new menuadmin(); this.Close(); aha.tabControl1.SelectedIndex = 2; aha.Show(); }
public Akun SearchAkun(String namaCustomer, String password) { string sql = "SELECT * FROM pegawai WHERE NAMA_PEGAWAI = '" + namaCustomer + "' AND PASSWORD = '******';"; Akun akun = null; try { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader result = cmd.ExecuteReader(); if (result != null) { while (result.Read()) { akun = new Akun( result.GetString("NAMA_PEGAWAI"), result.GetString("PASSWORD"), result.GetString("JABATAN"), result.GetInt32("ID_PEGAWAI")); } } } catch (Exception ex) { Console.WriteLine("Failed to search..."); Console.WriteLine(ex.ToString()); } return(akun); }
public int Create(Akun akun) { int result = 0; string sql = @"INSERT INTO Akun VALUES (@KodeKaryawan, @Username, @Password, @HakAkses)"; using (MySqlCommand cmd = new MySqlCommand(sql, _conn)) { cmd.Parameters.AddWithValue("@KodeKaryawan", akun.KodeKaryawan); cmd.Parameters.AddWithValue("@Username", akun.Username); cmd.Parameters.AddWithValue("@Password", akun.Password); cmd.Parameters.AddWithValue("@HakAkses", akun.HakAkses); try { result = cmd.ExecuteNonQuery(); } catch (Exception ex) { System.Diagnostics.Debug.Print("Create error: {0}", ex.Message); } } return(result); }
public int Create(Akun akun) { int result = 0; if (string.IsNullOrEmpty(akun.KodeKaryawan)) { MessageBox.Show("Kode karyawan harus diisi !", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(0); } if (string.IsNullOrEmpty(akun.Username)) { MessageBox.Show("Username harus diisi !", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(0); } if (string.IsNullOrEmpty(akun.Password)) { MessageBox.Show("Password harus diisi !", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(0); } using (DbContext context = new DbContext()) { _repository = new AkunRepository(context); result = _repository.Create(akun); } return(result); }
public FrmInputKaryawan(string title, Karyawan obj, KaryawanController controller, AkunController controllerAkun) : this() { lblHeader.Text = title; this.controller = controller; this.controllerAkun = controllerAkun; isNewData = false; karyawan = obj; akun = new Akun(); txtKodeKaryawan.Text = karyawan.KodeKaryawan; txtNamaKaryawan.Text = karyawan.Nama; if (karyawan.Gender == "L") { rdoLaki.Checked = true; } else { rdoPerempuan.Checked = true; } txtTelepon.Text = karyawan.Telepon; if (karyawan.HakAkses == "1") { cmbHakAkses.SelectedIndex = 0; } else { cmbHakAkses.SelectedIndex = 1; } }
public DaftarAkunForm(string nama, int umur, string password, string gender) { InitializeComponent(); mode = Mode.Edit; akun = new Akun { Username = nama, Umur = umur, Password = password, Gender = gender, }; tbNama.Text = nama; tbUmur.Text = Convert.ToString(umur); if (gender == "Laki-laki") { rbLaki.Checked = true; } else { rbPerempuan.Checked = true; } tbPassword.Text = password; tbKonfirmasiPass.Text = password; btnDaftar.Text = "Perbarui"; }
public bool Update(Akun akun) { using (var context = new PsboContext()) { var user = context.Akun.Find(akun.IdPegawai); if (user != null) { try { bool del = Delete(user); if (del) { bool upd = Add(akun); if (upd) { return(true); } } context.SaveChanges(); } catch (Exception ex) { throw; } } return(false); } }
public int Update(Akun akun) { int result = 0; string sql = @"UPDATE Akun SET Username = @Username, Password = @Password, HakAkses = @HakAkses WHERE KodeKaryawan = @KodeKaryawan"; using (MySqlCommand cmd = new MySqlCommand(sql, _conn)) { cmd.Parameters.AddWithValue("@Username", akun.Username); cmd.Parameters.AddWithValue("@Password", akun.Password); cmd.Parameters.AddWithValue("@HakAkses", akun.HakAkses); cmd.Parameters.AddWithValue("@KodeKaryawan", akun.KodeKaryawan); try { result = cmd.ExecuteNonQuery(); } catch (Exception ex) { System.Diagnostics.Debug.Print("Update error: {0}", ex.Message); } } return(result); }
public Akun IsValidAccess(Akun akunLogin) { var akun = new Akun(); try { string sql = @"SELECT K.Nama, A.KodeKaryawan, A.Username, A.Password, A.HakAkses FROM Akun A JOIN Karyawan K ON A.KodeKaryawan = K.KodeKaryawan WHERE A.Username LIKE BINARY @Username AND A.Password LIKE BINARY @Password"; using (MySqlCommand cmd = new MySqlCommand(sql, _conn)) { cmd.Parameters.AddWithValue("@Username", akunLogin.Username); cmd.Parameters.AddWithValue("@Password", akunLogin.Password); using (MySqlDataReader dtr = cmd.ExecuteReader()) { while (dtr.Read()) { akun.KodeKaryawan = dtr["KodeKaryawan"].ToString(); akun.Username = dtr["Nama"].ToString(); // Menyimpan nama karyawan akun.HakAkses = dtr["HakAkses"].ToString(); } } } } catch (Exception ex) { System.Diagnostics.Debug.Print("IsValidAccess error: {0}", ex.Message); } return(akun); }
void editpegawai_Click(object sender, RoutedEventArgs e) { Akun epeg = (Akun)dataGrid.SelectedItems[0]; editpegawai ep = new editpegawai(epeg); ep.Show(); this.Close(); }
public Akun Find(string u) { using (var context = new PsboContext()) { Akun ak = context.Akun.Where(o => o.Username == u).FirstOrDefault(); return(ak); } }
public ActionResult DeleteConfirmed(string id) { Akun akun = db.Akuns.Find(id); db.Akuns.Remove(akun); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult> DeleteConfirmed(string id) { Akun akun = await db.Akuns.FindAsync(id); db.Akuns.Remove(akun); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public popkasir(Akun akn, long i) { InitializeComponent(); tamtr.DataContext = detp; a = akn; idtrans.Text = Convert.ToString(i); idtr = i; detp.IdTrans = i; }
public Akun SearchAkun(String namaPegawai, String password) { Akun akun = null; aDAO.makeConnection(); akun = aDAO.SearchAkun(namaPegawai, password); aDAO.closeConnection(); return(akun); }
public ActionResult Edit([Bind(Include = "Username,Email,Password")] Akun akun) { if (ModelState.IsValid) { db.Entry(akun).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(akun)); }
public IActionResult Delete(Akun model) { if (!ModelState.IsValid) { return(BadRequest()); } _service.Delete(model); return(Ok(model)); }
public ActionResult Create([Bind(Include = "Username,Email,Password")] Akun akun) { if (ModelState.IsValid) { db.Akuns.Add(akun); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(akun)); }
public async Task <ServiceResponse <string> > Register(string username, string password, string nama, int struktur) { ServiceResponse <string> response = new ServiceResponse <string>(); if (username == null || password == null || struktur == 0 || nama == null) { response.Status = false; response.Message = "Tidak ada data yang dikirim"; return(response); } User user = new User(); if (await UserExists(username)) { response.Status = false; response.Message = "User Already Exists"; return(response); } CreatePasswordHash(password, out byte[] passwordHash, out byte[] passwordSalt); user.Username = username; user.PasswordHash = passwordHash; user.PasswordSalt = passwordSalt; user.Sistem_created_time = DateTime.Now; user.Sistem_updated_time = Convert.ToDateTime("1900-01-01"); user.Sistem_ip_create = _accessor.ActionContext.HttpContext.Connection.RemoteIpAddress.ToString(); user.Struktur = await _context.Tb_struktur.FirstOrDefaultAsync(u => u.Id == struktur); var akun = new Akun(); akun.nama_lengkap = nama; akun.Sistem_created_time = DateTime.Now; akun.Sistem_updated_time = Convert.ToDateTime("1900-01-01"); try { await _context.Tb_user.AddAsync(user); await _context.SaveChangesAsync(); akun.User = user; await _context.Tb_akun.AddAsync(akun); await _context.SaveChangesAsync(); response.Data = user.Username; response.Message = "Berhasil Menambahkan User"; } catch (Exception ex) { response.Status = false; response.Message = ex.Message; } return(response); }
public Akun Delete(Akun model) { if (model == null) { throw new ArgumentNullException(nameof(model)); } _repo.Delete(model); return(model); }
public void Add(Akun akun) { if (akun == null) { throw new ArgumentNullException(); } _context.Akun.Add(akun); _context.SaveChanges(); }
public void Delete(Akun akun) { if (akun == null) { throw new ArgumentNullException(); } _context.Akun.Remove(akun); _context.SaveChanges(); }
public IActionResult GetSingle(Guid id) { Akun akun = _service.GetSingle(id); if (akun == null) { throw new ArgumentNullException(); } return(Ok(akun)); }
public menukasir(Akun kasir) { id = repok.getId() + 1; InitializeComponent(); GridTransaksi.ItemsSource = repodt.Get(id); string u = kasir.Username; kasirq = repoak.Find(u); opr.Text = kasirq.NamaLengkap; nomOp.Text = Convert.ToString(id); }
public Akun IsValidAkses(Akun akunParameter) { var akun = new Akun(); using (DbContext context = new DbContext()) { _repository = new AkunRepository(context); akun = _repository.IsValidAccess(akunParameter); } return(akun); }
public lihatakun(Akun a) { using (var context = new PsboContext()) { lakun = context.Akun.Where(o => o.Username == a.Username).FirstOrDefault(); } InitializeComponent(); myprofile.DataContext = lakun; nowai.Text = Convert.ToString(lakun.NoHp); akun_nop.Text = Convert.ToString(lakun.NoPegawai); passwordBox.Password = lakun.Password; }
public IActionResult Add(Akun model) { model.Id = new Guid(); model.CreatedAt = new DateTime(); if (!ModelState.IsValid) { return(BadRequest()); } _service.Add(model); return(Ok(model)); }
// GET: Account/Delete/5 public async Task <ActionResult> Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Akun akun = await db.Akuns.FindAsync(id); if (akun == null) { return(HttpNotFound()); } return(View(akun)); }
// GET: Pengguna/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Akun akun = db.Akuns.Find(id); if (akun == null) { return(HttpNotFound()); } return(View(akun)); }