private void inscash()
{
koneksikuDataContext dbku = new koneksikuDataContext();
var chaspos = (from u in dbku.msemployees where u.position == "cashier" orderby u.employeeid descending select u).First();
string chaspost = chaspos.employeeid;
int start = +1;
msemployee mse = new msemployee();
if (chaspost != null)
{
string chasa = chaspost.Substring(3, 2);
int convertchas = Convert.ToInt32(chasa);
int tambah = convertchas + start;
string convst = Convert.ToString("CH-0" + tambah);
mse.name = "" + txtname.Text;
mse.email = "" + txtemail.Text;
mse.handphone = "" + txthp.Text;
mse.position = "" + cmbpost.SelectedItem;
mse.password = "" + txtpassword.Text;
mse.employeeid = "" + convst;
dbku.msemployees.InsertOnSubmit(mse);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
}
private void insertadmin()
{
string userem;
string conv;
int conv2id;
ManageEmployee me = new ManageEmployee();
msemployee mep = new msemployee();
var usera1 = (from s in dbku.msemployees where s.position == "admin" orderby s.employeeid descending select s).First();
string potong;
string user1;
string dapat;
int newid;
if (usera1 != null)
{
user1 = usera1.employeeid;
conv = Convert.ToString(user1);
potong = conv.Substring(2, 2);
conv2id = Convert.ToInt32(potong);
newid = conv2id + 01;
userem = Convert.ToString("A-0" + newid);
dapat = userem;
mep.name = "" + txtname.Text;
mep.email = "" + txtemail.Text;
mep.handphone = "" + txthp.Text;
mep.position = "" + cmbpost.SelectedItem;
mep.password = "" + txtpassword.Text;
mep.employeeid = "" + dapat;
dbku.msemployees.InsertOnSubmit(mep);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
else
{
string userid = "A-00".Substring(2, 2);
int convert = Convert.ToInt32(userid);
int newids = convert + 01;
string userid2 = Convert.ToString("A-0" + newids);
mep.name = "" + txtname.Text;
mep.email = "" + txtemail.Text;
mep.handphone = "" + txthp.Text;
mep.position = "" + cmbpost.SelectedItem;
mep.password = "" + txtpassword.Text;
mep.employeeid = "" + userid2;
dbku.msemployees.InsertOnSubmit(mep);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
}
private void deletedata()
{
msemployee mep = new msemployee();
var deluser = (from d in dbku.msemployees where d.employeeid == txtemid.Text select d).First();
dbku.msemployees.DeleteOnSubmit(deluser);
dbku.SubmitChanges();
MessageBox.Show("DATA USER BERHASIL DI HAPUS");
}
private void insertM()
{
var member1 = (from m in dbku.msemployees where m.position == "member" select m);
if (member1 == null)
{
msemployee emp = new msemployee();
int id = 0;
string members = "M-0";
string gabung;
int tambahm = id + 1;
gabung = members + id;
emp.email = txtemail.Text + "@smknus.com";
emp.password = "" + txtpassword.Text;
emp.handphone = "" + txthp.Text;
emp.name = "" + txtname.Text;
emp.position = "" + cmbpost.SelectedItem;
emp.employeeid = "" + gabung;
dbku.msemployees.InsertOnSubmit(emp);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
else
{
var member3 = (from m in dbku.msemployees where m.position == "member" orderby m.employeeid descending select m).FirstOrDefault();
msemployee mep = new msemployee();
string member2 = member3.employeeid.Substring(2, 2);
int convertmember = Convert.ToInt32(member2);
int tambah = convertmember + 1;
string convertidm = Convert.ToString("M-0" + tambah);
mep.name = "" + txtname.Text;
mep.email = "" + txtemail.Text;
mep.handphone = "" + txthp.Text;
mep.position = "" + cmbpost.SelectedItem;
mep.password = "" + txtpassword.Text;
mep.employeeid = "" + convertidm;
dbku.msemployees.InsertOnSubmit(mep);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
}
private void insertChef()
{
msemployee emp = new msemployee();
var chef = (from s in dbku.msemployees where s.position == "chef" orderby s.employeeid descending select s).First();
if (chef != null)
{
string user1 = chef.employeeid.Substring(2, 2);
int convid = Convert.ToInt32(user1);
int id1;
id1 = convid + 1;
string jadi = "C-" + id1;
emp.email = "" + txtemail.Text;
emp.password = "" + txtpassword.Text;
emp.handphone = "" + txthp.Text;
emp.name = "" + txtname.Text;
emp.position = "" + cmbpost.SelectedItem;
emp.employeeid = "" + jadi;
dbku.msemployees.InsertOnSubmit(emp);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
else
{
msemployee mep = new msemployee();
string user1 = "C-00".Substring(2, 2);
int converuser1 = Convert.ToInt32(user1);
int id1; string convertid;
id1 = converuser1 + 01;
convertid = Convert.ToString("C-0" + id1);
mep.name = "" + txtname.Text;
mep.email = "" + txtemail.Text;
mep.handphone = "" + txthp.Text;
mep.position = "" + cmbpost.SelectedItem;
mep.password = "" + txtpassword.Text;
mep.employeeid = "" + convertid;
dbku.msemployees.InsertOnSubmit(mep);
dbku.SubmitChanges();
MessageBox.Show("DATA PENGGUNA BERHASIL DI INPUT");
txtname.Text = null;
txtemail.Text = null;
txthp.Text = null;
txtpassword.Text = null;
}
}
private void bindtable()
{
koneksikuDataContext dbku = new koneksikuDataContext();
msemployee mep = new msemployee();
DataGridView datagrid = new DataGridView();
BindingSource bs = new BindingSource();
var ambil = (from s in dbku.msemployees select s).ToList();
datagrid.ColumnCount = 6;
datagrid.AutoGenerateColumns = false;
DataTable dt = new DataTable();
this.datagrid.DataSource = ambil;
}
private void update()
{
cmbpost.Enabled = false;
msemployee mep = new msemployee();
var updateus = (from u in dbku.msemployees where u.employeeid == txtemid.Text select u).First();
updateus.email = txtemail.Text + "@smknus.com";
updateus.handphone = txthp.Text;
updateus.password = txtpassword.Text;
updateus.name = txtemail.Text;
dbku.SubmitChanges();
txtemail.Text = "";
txtpassword.Text = "";
txtname.Text = "";
txthp.Text = "";
MessageBox.Show("DATA BERHASIL DI UPDATE");
this.bindtable();
datagrid.Update();
datagrid.Refresh();
}
partial void Deletemsemployee(msemployee instance);
partial void Updatemsemployee(msemployee instance);
partial void Insertmsemployee(msemployee instance);
