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