private void btn_hapus_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var index = gridView1.GetSelectedRows();
if (index.Count() > 0)
{
if (Helpers.Generic.MsgQuestion("Hapus data yang dipilih?") == DialogResult.Yes)
{
var data = new Models.karyawan()
{
kd_karyawan = gridView1.GetRowCellValue(index[0], "kd_karyawan").ToString()
};
Controllers.CKaryawan.delete(data);
}
}
this.init();
}
public static Models.karyawan check_login(string username)
{
var result = new Models.karyawan();
try
{
using (var db = new Models.sim_penjualanContext())
{
result = db.karyawans.Where(t => t.username == username).SingleOrDefault();
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
public static Models.karyawan check_login(string username, string password)
{
var result = new Models.karyawan();
try
{
using (var db = new Models.jotunContext())
{
return(db.karyawans.Where(t => t.username == username && t.password == password).SingleOrDefault());
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
public static bool insert(Models.karyawan data)
{
bool result = false;
try
{
using (var db = new Models.jotunContext())
{
db.Entry(data).State = EntityState.Added;
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
private void btn_simpan_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var txt = new TextEdit[] { txt_nama, txt_alamat, txt_email, txt_username, txt_password };
foreach (var t in txt)
{
if (t.EditValue.ToString() == "")
{
Helpers.Generic.MsgError(t.Tag.ToString() + " tidak boleh kosong");
t.Focus();
return;
}
}
var data = new Models.karyawan()
{
kd_karyawan = txt_kd_karyawan.EditValue.ToString(),
nama = txt_nama.EditValue.ToString(),
alamat = txt_alamat.EditValue.ToString(),
email = txt_email.EditValue.ToString(),
username = txt_username.EditValue.ToString(),
password = txt_password.EditValue.ToString(),
no_telepon = txt_no_telepon.EditValue.ToString(),
hak_akses = cbo_hak_akses.EditValue.ToString()
};
if (this.Text.ToLower().Contains("tambah"))
{
Controllers.CKaryawan.insert(data);
}
else
{
Controllers.CKaryawan.update(data);
}
var frm = (FrmKaryawan)this.Owner;
frm.init();
this.Close();
}
