private void button1_Click(object sender, EventArgs e)
{
RestaurantConfiguration.command = DataAccessCode.CreateCommand();
if (isDirtyRead)
{
RestaurantConfiguration.command.CommandText = "dbo.T1DirtyRead";
}
else
{
RestaurantConfiguration.command.CommandText = "dbo.T1ResolvedDirtyRead";
}
DataTable dt = DataAccessCode.ExecuteSelectCommand(RestaurantConfiguration.command);
List <ThongTinNhanVienDTO> list = new List <ThongTinNhanVienDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinNhanVienDTO thongTinNhanVien = new ThongTinNhanVienDTO();
thongTinNhanVien.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString());
//thongTinNhanVien.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
list.Add(thongTinNhanVien);
}
}
dgvData.DataSource = list;
}
private void m_btnThongTinHoanTatThemNV_Click(object sender, EventArgs e)
{
ThongTinNhanVienDTO nv = new ThongTinNhanVienDTO();
nv.Ho = m_txtThongTinHoNhanVien.Text.ToString();
nv.Ten = m_txtThongTinTenNhanVien.Text.ToString();
nv.CMND = m_txtThongTinCMND.Text.ToString();
nv.DiaChi = m_txtThongTinDiaChi.Text.ToString();
nv.DienThoai = m_txtThongTinDienThoai.Text.ToString();
nv.NgayVaoLam = m_dtpThongTinNgayVaolam.Value;
nv.TinhTrang = m_txtThongTinTinhTrang.Text.ToString();
if (m_cbxThongTinNhaHang.SelectedIndex == 0)
{
nv.MaNhaHang = -1;
}
else
{
nv.MaNhaHang = m_cbxThongTinNhaHang.SelectedIndex;
}
if (m_cbxThongTinLoaiNhanVien.SelectedIndex == 0)
{
nv.MaLoaiNhanVien = -1;
}
else
{
nv.MaLoaiNhanVien = m_cbxThongTinLoaiNhanVien.SelectedIndex;
}
ThongTinNhanVienBUS.AddThongTinNhanVien(nv);
//LoadDanhSachNhanVien();
ThongTinNhanVienDTO nvTimKiem = new ThongTinNhanVienDTO();
TimKiemNhanVien(nvTimKiem);
}
private void m_btnXoaNV_Click(object sender, EventArgs e)
{
ThongTinNhanVienBUS.DeleteThongTinNhanVien(Int32.Parse(m_txtThongTinMaNV.Text));
//LoadDanhSachNhanVien();
ThongTinNhanVienDTO nvTimKiem = new ThongTinNhanVienDTO();
TimKiemNhanVien(nvTimKiem);
}
/*private void ResetTruongDuLieuThongTin()
* {
* m_txtThongTinMaNV.Text = "";
* m_txtThongTinHoNhanVien.Text = "";
* m_txtThongTinTenNhanVien.Text = "";
* m_txtThongTinCMND.Text = "";
* m_txtThongTinDiaChi.Text = "";
* m_txtThongTinDienThoai.Text = "";
* m_txtThongTinTinhTrang.Text = "";
* m_dtpThongTinNgayVaolam.Value = DateTime.Today;
* m_cbxThongTinLoaiNhanVien.SelectedIndex = 0;
* m_cbxThongTinNhaHang.SelectedIndex = 0;
* }*/
private void TimKiemNhanVien(ThongTinNhanVienDTO nv)
{
nv.MaNhanVien = Int32.Parse(m_txtTimKiemMaNV.Text == "" ? "0" : m_txtTimKiemMaNV.Text);
nv.Ho = m_txtTimKiemHoNV.Text;
nv.Ten = m_txtTimKiemTenNV.Text;
nv.CMND = m_txtTimKiemCMND.Text;
nv.DienThoai = m_txtTimKiemDienThoai.Text;
nv.DiaChi = "";
if (m_cbxTimKiemNhaHang.SelectedIndex == 0)
{
nv.MaNhaHang = -1; //Tất cả
}
else if (m_cbxTimKiemNhaHang.SelectedIndex == m_cbxTimKiemNhaHang.Items.Count - 1)
{
nv.MaNhaHang = 0; //= null
}
else
{
nv.MaNhaHang = ((NhaHangDTO)m_cbxTimKiemNhaHang.SelectedItem).MaNhaHang;
}
if (m_cbxTimKiemLoaiNV.SelectedIndex == 0)
{
nv.MaLoaiNhanVien = -1;
}
else if (m_cbxTimKiemLoaiNV.SelectedIndex == m_cbxTimKiemLoaiNV.Items.Count - 1)
{
nv.MaLoaiNhanVien = 0;
}
else
{
nv.MaLoaiNhanVien = ((LoaiNhanVienDTO)m_cbxTimKiemLoaiNV.SelectedItem).MaLoaiNhanVien;
}
nv.NgayVaoLam = m_dtpTimKiemNgayVaoLam.Value;
int loaiTruyXuat = m_cbxLoaiTruyXuat.SelectedIndex;
List <ThongTinNhanVienDTO> dt = ThongTinNhanVienBUS.FindNhanVien(nv, loaiTruyXuat);
if (dt.Count > 0)
{
m_dgvDanhSachNhanVien.DataSource = dt;
UpdateDatagridviewDSNhanVien();
}
else
{
m_dgvDanhSachNhanVien.DataSource = null;
}
TinhTongNhanVien(nv.MaNhaHang, loaiTruyXuat);
}
private void m_btnTimKiem_Click(object sender, EventArgs e)
{
ThongTinNhanVienDTO nv = new ThongTinNhanVienDTO();
TimKiemNhanVien(nv);
/*nv.MaNhanVien = Int32.Parse(m_txtTimKiemMaNV.Text == "" ? "0" : m_txtTimKiemMaNV.Text);
* nv.Ho = m_txtTimKiemHoNV.Text;
* nv.Ten = m_txtTimKiemTenNV.Text;
* nv.CMND = m_txtTimKiemCMND.Text;
* nv.DienThoai = m_txtTimKiemDienThoai.Text;
* nv.DiaChi = "";
* if (m_cbxTimKiemNhaHang.SelectedIndex == 0)
* nv.MaNhaHang = -1; //Tất cả
* else if (m_cbxTimKiemNhaHang.SelectedIndex == m_cbxTimKiemNhaHang.Items.Count - 1)
* nv.MaNhaHang = 0; //= null
* else
* nv.MaNhaHang = ((NhaHangDTO)m_cbxTimKiemNhaHang.SelectedItem).MaNhaHang;
*
* if (m_cbxTimKiemLoaiNV.SelectedIndex == 0)
* nv.MaLoaiNhanVien = -1;
* else if (m_cbxTimKiemLoaiNV.SelectedIndex == m_cbxTimKiemLoaiNV.Items.Count - 1)
* nv.MaLoaiNhanVien = 0;
* else
* nv.MaLoaiNhanVien = ((LoaiNhanVienDTO)m_cbxTimKiemLoaiNV.SelectedItem).MaLoaiNhanVien;
* nv.NgayVaoLam = m_dtpTimKiemNgayVaoLam.Value;
*
* int loaiTruyXuat = m_cbxLoaiTruyXuat.SelectedIndex;
* List<ThongTinNhanVienDTO> dt = ThongTinNhanVienBUS.FindNhanVien(nv, loaiTruyXuat);
*
* if (dt.Count > 0)
* {
* m_dgvDanhSachNhanVien.DataSource = dt;
* UpdateDatagridviewDSNhanVien();
* }
* else
* m_dgvDanhSachNhanVien.DataSource = null;
*
*
* TinhTongNhanVien(nv.MaNhaHang, loaiTruyXuat);
*/
}
public ThongTinNhanVienDTO GetThongTinNhanVienTheoMaQuanLy(string MaQuanLy)
{
var result = new ThongTinNhanVienDTO();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = connectionStrings;
connection.Open();
using (connection)
{
SqlCommand sqlCom = new SqlCommand();
sqlCom.Connection = connection;
sqlCom.CommandText = "WebService_ThongTinNhanVienTheoMaQuanLy";
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.Parameters.Add(new SqlParameter("@MaQuanLy", MaQuanLy));
SqlDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
ThongTinNhanVienDTO item = new ThongTinNhanVienDTO();
item.MaCanBo = reader["MaQuanLy"] != DBNull.Value ? reader["MaQuanLy"].ToString() : "";
item.HoTen = reader["HoTen"] != DBNull.Value ? reader["HoTen"].ToString() : "";
var date = Convert.ToDateTime(reader["NgaySinh"].ToString());
item.NgaySinh = date.ToString("MM/dd/yyyy");
item.HocHam = reader["HocHam"] != DBNull.Value ? reader["HocHam"].ToString() : "";
item.HocVi = reader["HocVi"] != DBNull.Value ? reader["HocVi"].ToString() : "";
item.GioiTinh = reader["GioiTinh"].ToString();
item.QueQuan = reader["QueQuan"].ToString();
item.CMND = reader["CMND"].ToString();
var ngaycap = Convert.ToDateTime(reader["NgayCap"].ToString());
item.NgayCap = ngaycap.ToString("MM/dd/yyyy");
item.NoiCap = reader["NoiCap"].ToString();
item.TenChucVu = reader["TenChucVu"].ToString();
item.TenPhongBan = reader["TenBoPhan"].ToString();
item.DienThoai = reader["DienThoaiDiDong"].ToString();
item.Email = reader["Email"].ToString();
result = item;
}
}
return(result);
}
private void m_btnThongTinHoanTatSuaNV_Click(object sender, EventArgs e)
{
int loaiTruyXuat = m_cbxLoaiTruyXuat.SelectedIndex;
ThongTinNhanVienDTO nv = new ThongTinNhanVienDTO();
nv.MaNhanVien = Int32.Parse(m_txtThongTinMaNV.Text.ToString());
nv.Ho = m_txtThongTinHoNhanVien.Text.ToString();
nv.Ten = m_txtThongTinTenNhanVien.Text.ToString();
nv.CMND = m_txtThongTinCMND.Text.ToString();
nv.DiaChi = m_txtThongTinDiaChi.Text.ToString();
nv.DienThoai = m_txtThongTinDienThoai.Text.ToString();
nv.NgayVaoLam = m_dtpThongTinNgayVaolam.Value;
nv.TinhTrang = m_txtThongTinTinhTrang.Text.ToString();
if (m_cbxThongTinNhaHang.SelectedIndex == 0)
{
nv.MaNhaHang = 0;
}
else
{
nv.MaNhaHang = ((NhaHangDTO)m_cbxThongTinNhaHang.SelectedItem).MaNhaHang;
}
if (m_cbxThongTinLoaiNhanVien.SelectedIndex == 0)
{
nv.MaLoaiNhanVien = 0;
}
else
{
nv.MaLoaiNhanVien = ((LoaiNhanVienDTO)m_cbxThongTinLoaiNhanVien.SelectedItem).MaLoaiNhanVien;
}
ThongTinNhanVienBUS.EditThongTinNhanVien(nv, loaiTruyXuat);
//LoadDanhSachNhanVien();
ThongTinNhanVienDTO nvTimKiem = new ThongTinNhanVienDTO();
TimKiemNhanVien(nvTimKiem);
}
internal static List <ThongTinNhanVienDTO> LoadDanhSachNhanVien()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.T58LoadDanhSachNhanVien";
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <ThongTinNhanVienDTO> list = new List <ThongTinNhanVienDTO>();
if (dt != null)
{
int maNH;
int maLoai;
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinNhanVienDTO thongTinNhanVien = new ThongTinNhanVienDTO();
thongTinNhanVien.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString());
if (Int32.TryParse(dt.Rows[i]["MaNhaHang"].ToString(), out maNH))
{
thongTinNhanVien.MaNhaHang = maNH;
}
if (Int32.TryParse(dt.Rows[i]["MaLoaiNhanVien"].ToString(), out maLoai))
{
thongTinNhanVien.MaLoaiNhanVien = maLoai;
}
thongTinNhanVien.Ho = dt.Rows[i]["Ho"].ToString();
thongTinNhanVien.Ten = dt.Rows[i]["Ten"].ToString();
thongTinNhanVien.CMND = dt.Rows[i]["CMND"].ToString();
thongTinNhanVien.DiaChi = dt.Rows[i]["DiaChi"].ToString();
thongTinNhanVien.DienThoai = dt.Rows[i]["DienThoai"].ToString();
thongTinNhanVien.NgayVaoLam = DateTime.Parse(dt.Rows[i]["NgayVaoLam"].ToString());
thongTinNhanVien.TinhTrang = dt.Rows[i]["TinhTrang"].ToString();
list.Add(thongTinNhanVien);
}
}
return(list);
}
internal static List <ThongTinNhanVienDTO> FindNhanVien(ThongTinNhanVienDTO nv, int loaiTruyXuat)
{
return(ThongTinNhanVienDAO.FindNhanVien(nv, loaiTruyXuat));
}
internal static void AddThongTinNhanVien(ThongTinNhanVienDTO nv)
{
ThongTinNhanVienDAO.AddThongTinNhanVien(nv);
}
internal static void EditThongTinNhanVien(ThongTinNhanVienDTO nv, int loaiTruyXuat)
{
ThongTinNhanVienDAO.EditThongTinNhanVien(nv, loaiTruyXuat);
}
internal static void EditThongTinNhanVien(ThongTinNhanVienDTO nv, int loaiTruyXuat)
{
DbCommand command = DataAccessCode.CreateCommand();
if (loaiTruyXuat == 1)
{
command.CommandText = "dbo.T58LostUpdateEditThongTinNhanVien";
}
else if (loaiTruyXuat == 2)
{
command.CommandText = "dbo.T58LostUpdateSolvedEditThongTinNhanVien";
}
else if (loaiTruyXuat == 3)
{
command.CommandText = "dbo.T58DirtyReadEditThongTinNhanVien";
}
else if (loaiTruyXuat == 4)
{
command.CommandText = "dbo.T58DirtyReadSolvedEditThongTinNhanVien";
}
else if (loaiTruyXuat == 5 || loaiTruyXuat == 6)
{
command.CommandText = "dbo.T58UnrepeatableEditThongTinNhanVien";
}
else if (loaiTruyXuat == 7 || loaiTruyXuat == 8)
{
command.CommandText = "dbo.T58PhantomEditThongTinNhanVien";
}
else
{
command.CommandText = "dbo.T58EditThongTinNhanVien";
}
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhanVien";
param.Value = nv.MaNhanVien;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (nv.MaNhaHang == 0)
{
param.Value = 0;
}
else
{
param.Value = nv.MaNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@MaLoaiNhanVien";
if (nv.MaLoaiNhanVien == 0)
{
param.Value = 0;
}
else
{
param.Value = nv.MaLoaiNhanVien;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Ho";
if (nv.Ho == null)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.Ho;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Ten";
param.Value = nv.Ten;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CMND";
param.Value = nv.CMND;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@DiaChi";
param.Value = nv.DiaChi;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@DienThoai";
param.Value = nv.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@NgayVaoLam";
param.Value = nv.NgayVaoLam;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@TinhTrang";
if (nv.TinhTrang == "")
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.TinhTrang;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
internal static List <ThongTinNhanVienDTO> FindNhanVien(ThongTinNhanVienDTO nv, int loaiTruyXuat)
{
DbCommand command = DataAccessCode.CreateCommand();
if (loaiTruyXuat == 1)
{
command.CommandText = "dbo.T58LostUpdateTimKiemNhanVien";
}
else if (loaiTruyXuat == 2)
{
command.CommandText = "dbo.T58LostUpdateSolvedTimKiemNhanVien";
}
else if (loaiTruyXuat == 3)
{
command.CommandText = "dbo.T58DirtyReadTimKiemNhanVien";
}
else if (loaiTruyXuat == 4)
{
command.CommandText = "dbo.T58DirtyReadSolvedTimKiemNhanVien";
}
else if (loaiTruyXuat == 5)
{
command.CommandText = "dbo.T58UnrepeatableTimKiemNhanVien";
}
else if (loaiTruyXuat == 6)
{
command.CommandText = "dbo.T58UnrepeatableSolvedTimKiemNhanVien";
}
else if (loaiTruyXuat == 7)
{
command.CommandText = "dbo.T58PhantomTimKiemNhanVien";
}
else if (loaiTruyXuat == 8)
{
command.CommandText = "dbo.T58PhantomSolvedTimKiemNhanVien";
}
else
{
command.CommandText = "dbo.T58TimKiemNhanVien";
}
// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhanVien";
if (nv.MaNhanVien == 0)
{
param.Value = 0;
}
else
{
param.Value = nv.MaNhanVien;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (nv.MaNhaHang == 0)
{
param.Value = 0;//DBNull.Value;
}
else if (nv.MaNhaHang == -1)
{
param.Value = -1;
}
else
{
param.Value = nv.MaNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaLoaiNhanVien";
if (nv.MaLoaiNhanVien == 0)
{
param.Value = 0;
}
else if (nv.MaLoaiNhanVien == -1)
{
param.Value = -1;
}
else
{
param.Value = nv.MaLoaiNhanVien;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Ho";
if (nv.Ho == "")
{
param.Value = "";
}
else
{
param.Value = nv.Ho;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Ten";
if (nv.Ten == "")
{
param.Value = "";
}
else
{
param.Value = nv.Ten;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@CMND";
if (nv.CMND == "")
{
param.Value = "";
}
else
{
param.Value = nv.CMND;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DiaChi";
if (nv.DiaChi == "")
{
param.Value = "";
}
else
{
param.Value = nv.DiaChi;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DienThoai";
if (nv.DienThoai == "")
{
param.Value = "";
}
else
{
param.Value = nv.DienThoai;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@NgayVaoLam";
param.DbType = DbType.DateTime;
if (nv.NgayVaoLam == new DateTime())
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.NgayVaoLam;
}
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@TinhTrang";
if (nv.TinhTrang == "")
{
param.Value = "";
}
else
{
param.Value = nv.TinhTrang;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <ThongTinNhanVienDTO> list = new List <ThongTinNhanVienDTO>();
if (dt != null)
{
int temp;
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinNhanVienDTO thongTinNhanVien = new ThongTinNhanVienDTO();
if (Int32.TryParse(dt.Rows[i]["MaNhanVien"].ToString(), out temp))
{
thongTinNhanVien.MaNhanVien = temp;
}
else
{
thongTinNhanVien.MaNhanVien = 0;
}
if (Int32.TryParse(dt.Rows[i]["MaNhaHang"].ToString(), out temp))
{
thongTinNhanVien.MaNhaHang = temp;
}
else
{
thongTinNhanVien.MaNhaHang = 0;
}
if (Int32.TryParse(dt.Rows[i]["MaLoaiNhanVien"].ToString(), out temp))
{
thongTinNhanVien.MaLoaiNhanVien = temp;
}
else
{
thongTinNhanVien.MaLoaiNhanVien = 0;
}
thongTinNhanVien.Ho = dt.Rows[i]["Ho"].ToString();
thongTinNhanVien.Ten = dt.Rows[i]["Ten"].ToString();
thongTinNhanVien.CMND = dt.Rows[i]["CMND"].ToString();
thongTinNhanVien.DiaChi = dt.Rows[i]["DiaChi"].ToString();
thongTinNhanVien.DienThoai = dt.Rows[i]["DienThoai"].ToString();
thongTinNhanVien.NgayVaoLam = DateTime.Parse(dt.Rows[i]["NgayVaoLam"].ToString());
thongTinNhanVien.TinhTrang = dt.Rows[i]["TinhTrang"].ToString();
list.Add(thongTinNhanVien);
}
}
return(list);
}
internal static void AddThongTinNhanVien(ThongTinNhanVienDTO nv)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.T58AddThongTinNhanVien";
//// create a new parameter
DbParameter param = command.CreateParameter();
param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (nv.MaNhaHang == -1)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.MaNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaLoaiNhanVien";
if (nv.MaLoaiNhanVien == -1)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.MaLoaiNhanVien;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Ho";
if (nv.Ho == null)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.Ho;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Ten";
param.Value = nv.Ten;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@CMND";
param.Value = nv.CMND;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DiaChi";
param.Value = nv.DiaChi;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DienThoai";
param.Value = nv.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@NgayVaoLam";
param.Value = nv.NgayVaoLam;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@TinhTrang";
if (nv.TinhTrang == "")
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.TinhTrang;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
