public int InsertData(ChucVuEntity ChucVu) { SqlParameter[] para = { new SqlParameter("MaChucVu", ChucVu.MaChucVu), new SqlParameter("TenChucVu", ChucVu.TenChucVu) }; return(conn.ExcuteSQL("Them_CV", para)); }
public int UpdateData(ChucVuEntity ChucVu) { SqlParameter[] para = { new SqlParameter("MaChucVu", ChucVu.MaChucVu), new SqlParameter("TenChucVu", ChucVu.TenChucVu) }; return(conn.ExcuteSQL("SPSUACV", para)); }
public void Xoa(ChucVuEntity tk) { KetNoiCSDL.MoKetNoi(); string sql = @"DELETE tblChucVu WHERE MaChucVu=@MaNV"; SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect); cmd.Parameters.AddWithValue("@MaNV", tk.MaChucVu); cmd.ExecuteNonQuery(); KetNoiCSDL.DongKetNoi(); }
public void Sua(ChucVuEntity tk) { KetNoiCSDL.MoKetNoi(); string themhd = @"UPDATE tblTaiKhoan SET TenChucVu =@MatKhau, PhuCap =@TaiKhoan Where MaChucVu=@MaNV"; SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect); // cdm.CommandType = CommandType.StoredProcedure; cdm.Parameters.AddWithValue("@TaiKhoan", tk.PhuCap); cdm.Parameters.AddWithValue("@MatKhau", tk.TenChucVu); cdm.Parameters.AddWithValue("@MaNV", tk.MaChucVu); cdm.ExecuteNonQuery(); KetNoiCSDL.DongKetNoi(); }
public void Them(ChucVuEntity tk) { KetNoiCSDL.MoKetNoi(); string themhd = @"INSERT INTO tblTaiKhoan(MaChucVu, TenChucVu, PhuCap) VALUES (@TaiKhoan,@MatKhau,@MaNV)"; SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect); // cdm.CommandType = CommandType.StoredProcedure; cdm.Parameters.AddWithValue("@TaiKhoan", tk.MaChucVu); cdm.Parameters.AddWithValue("@MatKhau", tk.TenChucVu); cdm.Parameters.AddWithValue("@MaNV", tk.PhuCap); cdm.ExecuteNonQuery(); KetNoiCSDL.DongKetNoi(); }
public int UpdateData(ChucVuEntity CV) { return(chucvuDAl.UpdateData(CV)); }
public int InsertData(ChucVuEntity CV) { return(chucvuDAl.InsertData(CV)); }