private void btUpdate_Click(object sender, EventArgs e) { if (btUpdate.Text == "Thêm") { DBService db = new DBService(); db.openconn(); string ma = txtMa.Text; string ten = txtTen.Text; string gt = cbGioiTinh.Text; DateTime ns = datipickNgaySinh.Value; DateTime nl = datipickNgayLam.Value; string sdt = txtSDT.Text; string chucvu = txtChucVu.Text; string diachi = txtDiaChi.Text; string ghichu = txtGhiChu.Text; string username = txtUsername.Text; string password = txtPassword.Text; string sql1 = "insert into NHANVIEN values('" + ma + "',N'" + ten + "',CONVERT(DATETIME,'" + ns.ToString("dd/MM/yyyy") + "',103),CONVERT(DATETIME,'" + nl.ToString("dd/MM/yyyy") + "',103),'" + sdt + "',N'" + diachi + "',N'" + ghichu + "','" + gt + "')"; // them vao bang nv SqlCommand cmd1 = new SqlCommand(sql1, db.conn); SqlTransaction tran1 = db.conn.BeginTransaction("ThemLopTransaction"); cmd1.Transaction = tran1; try { cmd1.ExecuteNonQuery(); tran1.Commit();//kết thúc transaction } catch (Exception ex) { tran1.Rollback();//quay lui tới thời điểm beginTran throw ex; } string sql2 = "insert into TAIKHOAN values('" + ma + "','" + username + "','" + password + "','" + chucvu + "')"; // them vao bang taikhoan SqlCommand cmd2 = new SqlCommand(sql2, db.conn); //đánh dấu điểm bắt đầu SqlTransaction tran2 = db.conn.BeginTransaction("ThemLopTransaction"); cmd2.Transaction = tran2; try { cmd2.ExecuteNonQuery(); tran2.Commit();//kết thúc transaction } catch (Exception ex) { tran2.Rollback(); throw ex; } string sqlQuery = "insert into BioData values ('" + ma + "',N'" + pictureBox1.ImageLocation + "')"; SqlCommand cmd = new SqlCommand(sqlQuery, db.conn); SqlTransaction tran = db.conn.BeginTransaction("ThemLopTransaction"); cmd.Transaction = tran; try { cmd.ExecuteNonQuery(); tran.Commit();//kết thúc transaction } catch (Exception ex) { tran.Rollback(); throw ex; } db.closeconn(); MessageBox.Show("Thêm thành công", "Chúc mừng", MessageBoxButtons.OK, MessageBoxIcon.Information); } else //danh cho lenh Sua { DBService db = new DBService(); db.openconn(); string ma = txtMa.Text; string ten = txtTen.Text; string gt = cbGioiTinh.Text; DateTime ns = datipickNgaySinh.Value; DateTime nl = datipickNgayLam.Value; string sdt = txtSDT.Text; string chucvu = txtChucVu.Text; string diachi = txtDiaChi.Text; string ghichu = txtGhiChu.Text; string username = txtUsername.Text; string password = txtPassword.Text; string sql1 = "update NhanVien SET NV_name = N'" + ten + "', NV_birthday = CONVERT(DATETIME,'" + ns + "',103), NV_datework = CONVERT(DATETIME,'" + nl + "',103), NV_number = '" + sdt + "' , NV_address = N'" + diachi + "' , NV_note = N'" + ghichu + "', NV_gender = '" + gt + "' WHERE NV_id = '" + ma + "'"; // them vao bang nv SqlCommand cmd1 = new SqlCommand(sql1, db.conn); SqlTransaction tran1 = db.conn.BeginTransaction("ThemLopTransaction"); cmd1.Transaction = tran1; try { cmd1.ExecuteNonQuery(); tran1.Commit(); //kết thúc transaction } catch (Exception ex) { tran1.Rollback(); //quay lui tới thời điểm beginTran throw ex; } string sql2 = "update TaiKhoan SET Username = '******', Pass = '******', Acc_Type = '" + chucvu + "' where NV_id = '" + ma + "'"; SqlCommand cmd2 = new SqlCommand(sql2, db.conn); //đánh dấu điểm bắt đầu SqlTransaction tran2 = db.conn.BeginTransaction("ThemLopTransaction"); cmd2.Transaction = tran2; try { cmd2.ExecuteNonQuery(); tran2.Commit(); //kết thúc transaction } catch (Exception ex) { tran2.Rollback(); throw ex; } db.closeconn(); MessageBox.Show("Cập nhật thành công", "Chúc mừng", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }
private void btUpdate_Click(object sender, EventArgs e) { Regex reg = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"); if (reg.IsMatch(txtMail.Text)) { this.errorProvider1.SetError(txtMail, (string)null); } else { this.errorProvider1.SetError(txtMail, "Error"); } if (btUpdate.Text == "Thêm") { DBService db = new DBService(); db.openconn(); string ma = txtMa.Text; string ten = txtTen.Text; string sdt = txtSDT.Text; string email = txtMail.Text; float sotienno = float.Parse(txtSoTienNo.Text.ToString()); string ghichu = txtGhiChu.Text; string sql = "insert into KHACHHANG values('" + ma + "',N'" + ten + "', '" + sdt + "', '" + email + "', " + sotienno + ", N'" + ghichu + "')"; SqlCommand cmd = new SqlCommand(sql, db.conn); //đánh dấu điểm bắt đầu SqlTransaction tran = db.conn.BeginTransaction("ThemLopTransaction"); cmd.Transaction = tran; try { cmd.ExecuteNonQuery(); tran.Commit();//kết thúc transaction } catch (Exception ex) { tran.Rollback();//quay lui tới thời điểm beginTran throw ex; } db.closeconn(); MessageBox.Show("Thành công", "Chúc mừng", MessageBoxButtons.OK, MessageBoxIcon.Information); } else //danh cho lenh Sua { DBService db = new DBService(); db.openconn(); string ma = txtMa.Text; string ten = txtTen.Text; string sdt = txtSDT.Text; string email = txtMail.Text; float sotienno = float.Parse(txtSoTienNo.Text.ToString()); string ghichu = txtGhiChu.Text; string sql = "update KhachHang SET KH_name = N'" + ten + "', KH_number = '" + sdt + "', KH_mail = '" + email + "' , KH_scores = " + sotienno + " , KH_note = N'" + ghichu + "' WHERE NV_id = '" + ma + "'"; // them vao bang nv SqlCommand cmd = new SqlCommand(sql, db.conn); SqlTransaction tran = db.conn.BeginTransaction("ThemLopTransaction"); cmd.Transaction = tran; try { cmd.ExecuteNonQuery(); tran.Commit();//kết thúc transaction } catch (Exception ex) { tran.Rollback();//quay lui tới thời điểm beginTran throw ex; } db.closeconn(); MessageBox.Show("Cập nhật thành công", "Chúc mừng", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }