public ActionResult suaNhanVien(DANH_MUC_NGUOI_DUNG dmnd)
{
dmnd.TAIKHOAN = Request["txttaikhoan"].ToString();
dmnd.MATKHAU = Request["txtmatkhau"].ToString();
dmnd.HOTEN = Request["txthoten"].ToString();
dmnd.NHOMQUYEN = Request["txtnhomquyen"].ToString();
dmnd.GIOITINH = Convert.ToInt32(Request["txtgioitinh"]);
dmnd.NGAYSINH = Convert.ToDateTime(Request["txtngaysinh"]);
dmnd.SODIENTHOAI = Request["txtsodienthoai"].ToString();
dmnd.EMAIL = Request["txtemail"].ToString();
dmnd.MADIACHI = Convert.ToInt32(Request["txtdiachitinhthanhpho"]);
dmnd.CHITIETDIACHI = Request["txtdiachisonha"].ToString() + Request["txtdiachixa"].ToString() + Request["txtdiachiquanhuyen"].ToString() + Request["txtdiachitinhthanhpho"].ToString();
dmnd.VITRICONGTAC = Convert.ToInt32(Request["txtvitricongtac"]);
dmnd.TRANGTHAI = Convert.ToInt32(Request["txttrangthai"]);
var nv = new Models.NhanVienModel();
nv.suaNhanVien(dmnd);
return(RedirectToAction("DSnhanvien", "Nhanvien"));
}
public bool suaNhanVien(DANH_MUC_NGUOI_DUNG dmnd)
{
db = new ConnectDb();
SqlCommand cmd = new SqlCommand("UPDATE_DANH_MUC_NGUOI_DUNG", db.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TAIKHOAN", dmnd.TAIKHOAN));
cmd.Parameters.Add(new SqlParameter("@MATKHAU", dmnd.MATKHAU));
cmd.Parameters.Add(new SqlParameter("@NHOMQUYEN", dmnd.NHOMQUYEN));
cmd.Parameters.Add(new SqlParameter("@HOTEN", dmnd.HOTEN));
cmd.Parameters.Add(new SqlParameter("@GIOITINH", dmnd.GIOITINH));
cmd.Parameters.Add(new SqlParameter("@NGAYSINH", dmnd.NGAYSINH));
cmd.Parameters.Add(new SqlParameter("@SODIENTHOAI", dmnd.SODIENTHOAI));
cmd.Parameters.Add(new SqlParameter("@EMAIL", dmnd.EMAIL));
cmd.Parameters.Add(new SqlParameter("@MADIACHI", dmnd.MADIACHI));
cmd.Parameters.Add(new SqlParameter("@CHITIETDIACHI", dmnd.CHITIETDIACHI));
cmd.Parameters.Add(new SqlParameter("@MAVITRICONGTAC", dmnd.VITRICONGTAC));
cmd.Parameters.Add(new SqlParameter("@TRANGTHAI", dmnd.TRANGTHAI));
cmd.ExecuteNonQuery();
return(true);
}
public List <DANH_SACH_NHAN_VIEN_1> getAllNhanVien()
{
db = new ConnectDb();
List <DANH_SACH_NHAN_VIEN_1> list = new List <DANH_SACH_NHAN_VIEN_1>();
SqlCommand cmd = new SqlCommand("SELECT_DANH_SACH_NHAN_VIEN", db.conn);
cmd.CommandType = CommandType.StoredProcedure;
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
DANH_MUC_NGUOI_DUNG item_danh_muc_nguoi_dung = new DANH_MUC_NGUOI_DUNG();
DANH_MUC_DIA_CHI item_danh_muc_dia_chi = new DANH_MUC_DIA_CHI();
DANH_MUC_GIOI_TINH item_danh_muc_gioi_tinh = new DANH_MUC_GIOI_TINH();
item_danh_muc_nguoi_dung.TAIKHOAN = (string)sdr["TAIKHOAN"];
item_danh_muc_nguoi_dung.MATKHAU = (string)sdr["MATKHAU"];
item_danh_muc_nguoi_dung.HOTEN = (string)sdr["HOTEN"];
item_danh_muc_gioi_tinh.CHITIET = (string)sdr["CHITIET"];
item_danh_muc_nguoi_dung.NGAYSINH = (DateTime)sdr["NGAYSINH"];
item_danh_muc_nguoi_dung.SODIENTHOAI = (string)sdr["SODIENTHOAI"];
item_danh_muc_nguoi_dung.EMAIL = (string)sdr["EMAIL"];
item_danh_muc_dia_chi.TENDIACHI = (string)sdr["TENDIACHI"];
item_danh_muc_nguoi_dung.CHITIETDIACHI = (string)sdr["CHITIETDIACHI"];
item_danh_muc_nguoi_dung.TRANGTHAI = (int)sdr["TRANGTHAI"];
list.Add(new DANH_SACH_NHAN_VIEN_1(item_danh_muc_nguoi_dung.TAIKHOAN,
item_danh_muc_nguoi_dung.HOTEN,
item_danh_muc_nguoi_dung.MATKHAU,
item_danh_muc_gioi_tinh.CHITIET,
item_danh_muc_nguoi_dung.NGAYSINH,
item_danh_muc_nguoi_dung.SODIENTHOAI,
item_danh_muc_nguoi_dung.EMAIL,
item_danh_muc_dia_chi.TENDIACHI,
item_danh_muc_nguoi_dung.CHITIETDIACHI,
item_danh_muc_nguoi_dung.TRANGTHAI));
}
return(list);
}
