private void btninsert_Click(object sender, EventArgs e) { OpenFileDialog ofp = new OpenFileDialog(); byte[] fileb = imgtoarray(pbfood.Image); System.Data.Linq.Binary filebi = new System.Data.Linq.Binary(fileb); string paths = txtpath.Text; //System.Data.Linq.Binary pathbi = new System.Data.Linq.Binary(paths); int menus = Convert.ToInt32(txtmenuid.Text); int prices = Convert.ToInt32(txtprice.Text); var tabs = new msmenu { menuid = menus, photo = filebi, name = txtmenun.Text, price = prices, path = txtpath.Text, }; dbku.msmenus.InsertOnSubmit(tabs); dbku.SubmitChanges(); MessageBox.Show("Successfull"); this.bind(); dgrid.Refresh(); }
private void button1_Click(object sender, EventArgs e) { msmenu sm = new msmenu(); var userpass = (from u in dbku.msemployees where u.password == txtoldpass.Text select u).First(); string newpass1 = txtnewpass1.Text; string newpass2 = txtnewpass2.Text; string oldpass = txtoldpass.Text; if (oldpass == userpass.password) { if (newpass1 == newpass2) { userpass.password = newpass1; dbku.SubmitChanges(); MessageBox.Show("Password Berhasil Di Perbaharui"); } else { MessageBox.Show("Password Tidak Cocok, Silahkan Check Kembali"); oldpass = ""; newpass1 = ""; newpass2 = ""; } } else { MessageBox.Show("Password Lama Salah"); oldpass = ""; newpass1 = ""; newpass2 = ""; } }
partial void Updatemsmenu(msmenu instance);
partial void Deletemsmenu(msmenu instance);
partial void Insertmsmenu(msmenu instance);