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));
}
