public Boolean ThemTangLuong(TangLuong pb)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlThem = "INSERT INTO TangLuong VALUES(@MaPB ,@MaNV , @HoTen , @GioiTinh , @ChucVu , @MaLuong , @NgayTang)";
SqlCommand cmd = new SqlCommand(sqlThem, conn);
cmd.Parameters.AddWithValue("MaPB", pb.MaPB);
cmd.Parameters.AddWithValue("MaNV", pb.MaNV);
cmd.Parameters.AddWithValue("HoTen", pb.HoTen);
cmd.Parameters.AddWithValue("GioiTinh", pb.GioiTinh);
cmd.Parameters.AddWithValue("ChucVu", pb.ChucVu);
cmd.Parameters.AddWithValue("MaLuong", pb.MaLuong);
cmd.Parameters.AddWithValue("NgayTang", pb.NgayTang);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean SuaTangLuong(TangLuong pb)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlSua = "DECLARE @dem int select @dem = COUNT(MaNV) FROM TangLuong WHERE MaNV = @MaNV " +
"IF @dem != 0 UPDATE TangLuong SET MaLuong = @MaLuong , NgayTang = @NgayTang WHERE MaNV = @MaNV else raiserror('',16,1)";
SqlCommand cmd = new SqlCommand(sqlSua, conn);
cmd.Parameters.AddWithValue("MaNV", pb.MaNV);
cmd.Parameters.AddWithValue("MaLuong", pb.MaLuong);
cmd.Parameters.AddWithValue("NgayTang", pb.NgayTang);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean UpdateTangLuong(string MaPB, string MaNV, string HoTen, string GioiTinh, string ChucVu, string MaLuong, DateTime NgayTang)
{
DataProviderTangLuong dp = new DataProviderTangLuong();
TangLuong bh = new TangLuong(MaPB, MaNV, HoTen, GioiTinh, ChucVu, MaLuong, NgayTang);
return(dp.SuaTangLuong(bh));
}
